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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
