> I've got an ECommerce site and every page but the home > page loads reasonably fast however the home page takes > an average of 24 seconds to process - when I debug and > add up the process time of all the queries that are > running, they only total 160 milliseconds... which > makes no sense to me...
Maybe it's not the queries which are slow? Maybe the server is overwhelmed, so it has to wait longer to get database connections, etc, and your queries themselves are only taking a fraction of that time. > With debug on each query that's run shows the time like > this: GetHomeProduct (Records=6, Time=10ms) > > Does this mean it took 10 milliseconds to run that query > and get all six records, or 10 milliseconds for every record? It means that the entire query took ten milliseconds, more or less - CF has a margin of error around 10 milliseconds, if I recall correctly. > How else can I determine the cause of the slowdown? The slowdown could be caused by something else entirely. If you can, use a load test to find your site's bottlenecks. Then, within those bottlenecks, use GetTickCount to divide your page into sections, and find the slow sections. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
