> my problem is i saw a section in a book that told me i could > query a whole database, and then to speed up my queries i can > just query that query, but i can't remember how it said to do > it, and i can't find anything on the net that tells me how to > do it
Unless you have some SERIOUS processing going on within a given page, there would be no reason to store an entire database in a CF variable. Allowing the database server to take care of the caching and performance is probably your best bet. Query of Queries is a nice feature to have around if there is a specific table that you query several times on a given page with subtle changes to the WHERE clause. In this case you would query all of the fields you need from a table (or tables), then run queries against the results. <!--- Get all the data from this table. ---> <cfquery datasource="something" name="qMaster"> select * from table </cfquery> <!--- Get the newbs. ---> <cfquery dbtype="query" name="newbies"> select id, username from qMaster where beenprogramming = 'notlong' </cfquery> <!--- Get those coding for a while. ---> <cfquery dbtype="query" name="oldfarts"> select id, username from qMaster where beenprogramming = 'forever' </cfquery> ..and so on. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
