http://www.learnasp.com/advice/whygetrows.asp is the real answer to your efficiency issues.
The issues you raise below are all abotu better performance fo connection pooilng but GetRows and GetString blows their doors off anyway. In your example below you are also confusing recordsets with connections. Close connections yes (after the corresponding RS is closed) so it ends up back in the pool for other round-robin code see: http://www.learnasp.com/advice/dbpooling.asp Of course http://www.learnasp.com/advice/whygetrows.asp sort of makes it all moot anyway and will speed the heck out of your code. At 03:20 PM 9/20/2004, you wrote: >Hi All, > >I'm relatively new to the Classic ASP scene, and I read the "Round- >Robin Code Execution by Charles Carroll" article from learnasp.com. >I understand the importance of closing connections early, but I have >a question about this: > > > >================================================== >My current practice: >================================================== >rs.open1 >process rs >... >rs.open2 >process rs >... >rs.open3 >process rs >... >rs.open4 >process rs >... >rs.close > >My question to the group is, is what I am doing equivalent to bad >practice? I am declaring one recordset variable, pulling one >recordset into it, processing the data, then overwriting the >recordset variable by pulling another recordset into it, processing >the data, etc., etc. and then closing the recordset variable at the >end. I just want to be able to cut down on resources usage on the >server side. Thanks in advance. ---------- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.754 / Virus Database: 504 - Release Date: 9/6/2004 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
