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:
================================================== Bad practice (from learnasp.com): ================================================== rs1.open rs2.open rs3.open rs4.open ... process rs1 ... process rs2 ... process rs3 ... process rs4 rs1.close rs2.close rs3.close rs4.close ================================================== Good practice (from learnasp.com): ================================================== rs1.open process rs1 rs1.close ... rs2.open ... process rs2 rs2.close rs3.open ... process rs3 rs4.close rs4.open .. process rs4 rs4.close ================================================== 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. ------------------------ 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/
