Pete, What are you actually doing with the client variables when you hit a page?
Using a datasource, especially a distributed server, is going to be slower than using registry. Well, until the registry fills, in which case your entire server will grind to a painful halt. Its a bit of a trade off between not killing your server and a little bit of speed loss. Thing is, I have no idea why it would take 3 to 5 seconds, instead of immediate with registry. You could have any number of bottle necks. The code itself, the database connection type, on the datasource set up; page timeouts, buffer size, connection maintenance, simultaneous connection limits, performance tuning on the database, network noise...... One thing to try (in advance - please don't kill me for using the following words) try using an Access datasource as the client store on the CF server. Hopefully it will help to direct you to what might be the problem with your client variables. If its still really slow, then potentially its a problem with your code or the datasource set up, if its not then, you're looking at a problem with the network connection/database configuration etc. Hope that helps Stephen ----- Original Message ----- From: "pete ellefson" <[EMAIL PROTECTED]> To: "CF-Server" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 5:34 PM Subject: client variables again.... > 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
