• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

Disconnected Recordsets - Performance Benefits and Disadvantages

Hi all
Just wondering, how much better is using disconnected recordsets over connected recordsets and are they worth using?? Like, could the system support 1.5 times as many users simply by implementing this conversion?
  • 2
3 Solutions
Hi CVSmarc,

I don't think having disconnected recordsets can increase the system support by 1.5 times. In any case, it's no no to me to use connected recordsets in the web because it's difficult to know if the client connection has been disconnected or left hanging there by the user.

That said, if you looking to improve the efficiency of system significantly, u can look at few areas

1) ASP page caching as in the ASP.NET

2) Improving your SQLs and DML. Where possible reduce cursor loopings as much as possible.

3) Use AJAX !!!! (i.e. refresh only the part of the page where it is needed instead of refreshing and rewriting the whole page)

These improvements, if done correctly, can go well beyond 1.5 times!!!

In order to give a better answer to your question, I'd like to ask you to give your definition of connected and disconnected recordsets. For example, the lines of code you use for each.
In general, the recordset objects we use in ASP are usually disconnected (in my definition.) I mean, they are created, loaded with information, the information is used by the page, and as the page finishes its execution, the recordset object is gone. (I suppose the recordset object is created in the page code, and not in global.asa for example.)
ASP is a request based language (if we can call it a language!) The code is run "only" when a request is made to the server. As the page is fully rendered and sent to the client, the whole objects created inside the page are gone.
Wish I can help
I would first try to find the bottleneck for performance. Is that a certain page? Are there too many connections? If you make an ASP-page perform much better, but that ASP-page is hardly ever visited, the effect on overall performance is quite low.

In some cases you can "cache" data in an XML file. Especially when it is about data that does not change often.
And now that "caching" the data on server side has been suggested for some times, I'd like to add some links, for your information:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now