Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Why Obtain Recordset From Middle-Tier?

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?

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.



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