I don't believe there is a limit, but performing a large number of queries
is nowhere near as fast as a well tuned stored procedure and letting SQL
manage the operation. Sometimes it's easier to do pieces of the data
manipulation in CF, but where possible I would suggest consolidating the
logic and doing it in a stored procedure. As your site scales, all those
queries will probably become ineffecient and slow down the system.
--Doug
-----Original Message-----
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 28, 2000 6:57 PM
To: [EMAIL PROTECTED]
Subject: Too many queries?
Does CF have a maximum number of queries per request? I'm afraid some of my
pages will eventually query a DB many (many) times. I can change the DB
design to reduce the number of queries, and need to decide whether to do
this now or regret it later...
Thanks!
Norman Elton
Information Technology
The College of William & Mary
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
