no i kinda like it and figured id do nothing to improve it. i kinda like things nice and slow, what's rush? lol
keep in mind we took a site optimized to run on a unix/mysql environment and moved to windows/sql server. There is no way I'll be able to speed it up and tweak it so it runs quickly without a little bit of testing. And of course I can only test by having you all use the forum for real so we can see the load etc. so no the plan is not for it to be permenant, figured that was a given. I'll be making a few updates tonight that should help and runing a trace on the database to find out whats the major culprit. This is a HUGE db yet i have dbs 5 times the size that are never slow. It hasn't been indexed or optimized ever as far as I know so these probems should diminish in the next day or so. Thanks for your patience. now could ya pass the bowl?
K