Sure it works nicely, but if you have 1000 users pulling millions of rows each, that's going to put a large load on your server that really doesn't need to be there, not to mention network traffic if the DB server and CF server are separate. That's what I'm trying to avoid.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 12:25 PM To: CF-Talk Subject: RE: SQL row select? Here's a post from a DBA I'm friends with: <QUOTE> Just pull the entire query over to CF and use query of queries, to grab your "paged" row sets. I work with record sets of millions and it works very nicely. </QUOTE> <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
