Solved

Disconnected Recordsets - Performance Benefits and Disadvantages

Posted on 2006-07-03
6
423 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sending ASP to server side 8 43
ASP Classic, check if Querystring is UCase or LCase 10 36
Can't select treeview node from iframe 2 54
PHP $_POST vs asp request 4 57
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…

751 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