Here is a query in the application initialize method in spectra 1.5.1. This query is to test the existence and functioning of the objects table in the specified application database. It will make SQL server / oracle / whatever effectively do a row scan on the objects table. If you have more than a few thousand objects in the table, this could be a little slow. Even though maxrows="1" is set, this will not come through to SQL, so although CF is limiting the rows to one, SQL server will not. Causing pain and suffering when the CF server is restarted. Current query: <cfquery name="getobject" datasource="#spectraApp.datasource#" maxrows="1"> select objectid from objects </cfquery> The query can be changed to the following, which achieves the same thing without deep frying the SQL box. <cfquery name="getobject" datasource="#spectraApp.datasource#" maxrows="1"> select top 1 objectid from objects </cfquery> There is also another query on the extendeddata table just below it (not that there are many objects in it) that you may wish to make the same change to. These changes have *significantly* speed up the application initialize for the first page hit on the website I've been looking at (about 70000 objects in the database). Cheers, Aaron. /**************************************** Aaron Shurmer Senior Developer Daemon Internet Consultants ph +61 (0) 2 9380 4162 http://www.daemon.com.au/ engineered.innovation ****************************************/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
