> Since Access queries are also available as tables, is there any preference
> (performance, stability, etc) between storing them in the .mdb file and
> using them from CFQUERY or writing more complex queries directly inside
> CFQUERY?
Yep. Stored queries already have plan of request like sequence of indexes
and should run faster then dynamic SQL in CF> In other words DBJet will not
compile stored queries. :)
Gennadi
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
