Hey, Well, it can vary on record size - from 100 to 1000K+ (when not paged) and it is well documented that Java/CF doesnt handle large recordsets as 'efficiently' - in as far as mem usage as CF5 does - jeez, even the MM technotes practically note: "use smaller recordsets" -I believe it is around 2-4x more memory with Java call than CF5 used.
But when it comes to returning several recordsets (when there is absolutely no problem with it in QA) - CF can freak (or probably the driver does!); it can sometimes just bomb out with no error. There are good sides and downsides of using T-SQL SP's over inline - and I suppose we should be thankful we are not on the ASP and the go awful way it uses ADO ;-) I just prefer SP's for portability from a SQL perspective in our various languages such as .NET, I also like the way it reduces the amount of CFQueries I have to write...as like most, I am just too damn lazy to code more than I have to ;-) -----Original Message----- From: Dave Watts To: CF-Talk Sent: 31/10/2005 16:50 Subject: RE: Philosophy Q: SP's or CFQUERY? > This is through experience; try and run some CPU intensive > processes and see how badly the DataDirect driver performs I'm not sure what you mean by "CPU-intensive", since most of the work is being done by the database. Are you simply referring to large recordsets? If so, are you also saying that fetching those same recordsets using inline SQL performs better? Again, this has not been my experience at all (so far - perhaps I've been lucky). Also, when you say "large recordsets", how much data are you talking about? Again, I'm not trying to be critical - you may This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222766 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54