Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: COM/DCOM/COM+
Expertise: Beginner
Apr 13, 2000

Why Obtain Recordset From Middle-Tier?

Question:
I read the article 'Obtaining Recordset From Middle-Tier COM Component' and now am wondering why one would want to do this. As I understand it, this is only a difficult way of getting the same result as one would get if they used the ado.recordset directly in the ASP-page. The perfomance gain of this would be zero; or am I wrong?

Answer:
Typically, the middle tier handles your business rules and any interfaces to the database. In a system I built recently, I have a middle tier object that is managed by MTS and keeps a database connection open that can be shared by any object that needs it. The "business" object, which runs a bunch of queries to get the result data back, returns a disconnected recordset to the ASP page. The ASP page never has to mess with the overhead of a database connection in the page. This makes performance much better, since opening the database is computationally expensive.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date