A couple suggestions: Make sure the indexes are correct on the CFClient database (I would use a separate database than the rest of the app). Check the " Disable global client variable updates" (unless you really need them) Set max connection limits to the CFClient datastore (mine are set 6 per server)
Cheers -----Original Message----- From: pete ellefson [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 11:51 AM To: CF-Server Subject: Re: client variables again.... the machines are both identical. dual pentium 300's with 512ram i think. they are fine, and not under much load.. the funny thing is we had this same exact setup at our previous co-lo, and when we moved we re-installed the OS's and the only difference is we went from cf4.5 to 5... other than that the machines are identical, and configured the same as they were. we didn't have this problem before moving/reinstalling them. i thought of the Access idea on the webserver box...hehe. i could try that. we did try to install sql on the webserver, and there is some weird issue that wont let it install. could be a remote install limitation, but i thought you can install it remotely. so anyway we couldn't get that to take.. if it was a problem with code, why would it be fast w/ the registry, but slow with the db?? .and why was it fast before using the db? it it's a db connection issue, why are all db queries fast, and pages loading fast once client variables are done? .plus when the clientvar's are in the registry, the pages execute very fast, and are all using the db the same?? this is very strange, and i need a solution quick!!! thanks for all the help so far! pete At 05:54 PM 3/11/2002, you wrote: >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 > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
