How many indexes do you have setup on the table? I had a table with about 6 million records that I inherited and it only had an index setup on the primary key. It caused about 300-3000ms overhead on any page that accessed it. It took me a couple days but once I found it and added the indexes that were most commonly used (in this case only 1 that had 2 conditions), it reduced that 300-3000 to about 3ms. Just some food for thought.
the post on the phpbb pages from the go gaia developer is here: http://www.phpbb.com/community/viewtopic.php?f=18&t=135383 Sorry, some of it is phpbb specific but there are a lot of good posts in the topic about indexing and some other types of performancing tweaking. I found it really interesting anyhow :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
