Good db question, Bernd! I've got a query that's pulling around 45k records and we are only displaying 500 records at a time; is the only way we can speed up the s.o.b. by cache-ing the query on repetitive calls to the db? There's got to be a better SQL way of doing this...(also: it has to sort the entire data set at the same time)
Tyler ----- Original Message ----- From: "Bernd VanSkiver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 9:48 AM Subject: Re: maxrows question Is is possible to specify a starting row with SQL similar to the startrow="" parameter in <cfoutput>? Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ----- Original Message ----- From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 8:36 AM Subject: RE: maxrows question > All the records are returned by the DB. So, if you can use SQL instead > of MAXROWs, it would probably be marginally better performance wise. For > example, if you want the first X records, I know SQL Server lets you do: > > SELECT TOP 10 Foo, Goo, YourBoots > FROM .... > > ======================================================================= > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 29, 2001 9:31 AM > > To: CF-Talk > > Subject: maxrows question > > > > > > Does anyone know if i set a maxrow value of 1 in a select query, > > if just one record is passed to coldfusion by the database or > > all matching results are returned by the database but only one is made > > available? > > > > > > Kola Oyedeji |Web Developer |ekeda > > elthorne gate |64 high street |pinner |middx |ha55qa > > t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists