Hi Alister,
I bet you could speed up those query times even more.. If all you are
trying to do is get the objectid of the object(s) you are searching for, you
should be writing your query like this:
<cfquery datasource="dentalshop" name="get_nav">
SELECT objectid
FROM objects
WHERE typeid = '#url.cat1#'
</cfquery>
While it doesn't seem like much, you have to realize that doing a "SELECT *"
means that your RDBMS has to return ALL information about EACH object, thus
possibly resulting in a huge amount of information being passed between your
webserver & your RDBMS. You definitely want to keep the information flowing
between your DB server and your webserver to a minimum. If you have a
limited amount of categories, you might also look at programatically caching
the queries for those categories... bringing the query results from RAM will
be much quicker than doing a call to your DB. As always you have to find
the optimal balance between using your web servers RAM and your need for
speed.
Somewhat on topic, there's an article on allaire.com regarding property
searches with SQL you may want to take a look at:
Optimizing Allaire Spectra Property Searches with SQL
http://www.allaire.com/handlers/index.cfm?ID=19507
HTH
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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.
