devxlogo

Why Obtain Recordset From Middle-Tier?

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.

See also  5 Tips for Choosing the Right Medical Software for Your Practice
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist