ok, just to re-cap. win2k, cf5 on on the webserver win2k, sql7 on the db machine.
our apps run very fast when the cf setting for client variables is the registry.... but we know we can't leave it there. when i switch it to the database, it gets slow. not as slow as last time, now that it's being indexed.... but, still to slow to be acceptable. so exactly what can i do to index the client var. database to make it as fast as possible? i have a sql maintenance plan indexing every 2 hours... should i index every 1/2 hour instead of 2 hours? should i make it "shrink database" when it grows beyond 5 mb. instead of 20??? what can i do to make it faster? the symtom is for sure the client variables... what happens now is it takes 3-5 seconds for the page to start loading, then bam it's there. but when the client variabls are set for the registry, there is no delay, and is lightning fast. any help appreciated! pete ______________________________________________________________________ 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, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
