Solved

Disconnected Recordsets - Performance Benefits and Disadvantages

Posted on 2006-07-03
6
417 Views
Last Modified: 2008-01-09
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?
Thanks
ant
0
Comment
Question by:CVSmarc
  • 2
6 Comments
 
LVL 17

Accepted Solution

by:
NicksonKoh earned 168 total points
ID: 17035422
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!!!

Cheers
Nickson
0
 
LVL 14

Assisted Solution

by:huji
huji earned 166 total points
ID: 17041394
CVSmarc,
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
Huji
0
 
LVL 28

Assisted Solution

by:sybe
sybe earned 166 total points
ID: 17048393
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.
0
 
LVL 14

Expert Comment

by:huji
ID: 17048481
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:
http://www.asp101.com/articles/john/server_side_caching/index.asp
http://www.asp101.com/articles/contrib/pagecaching.asp
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using Currency Layer API within ASP 10 82
syntax error on ASP ? 6 43
ASP Sessions Being Cleared/Modified 6 65
Generate report pulling data (links) from three tables 31 59
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now