Russ I realise that Access has a problem (which is why everything is being slowly converted to MySQL). There are about 350 *separate* Access databases (yes, that's databases, not tables), each one related to a different town/region. And the bloody thing is live!
What I'm trying to do is to allow plenty of overall access to the site (they won't all be wanting info on one town at the same time), by keeping that main 'simultaneous connections' setting at 100 and perhaps limiting connections on each mdb to 5, or lower. Any further thoughts as to whether the architecture in CF is going to barf if I set it up this way? Cheers Terry ----------Original Message--------- > If your using access, 100 will take your server down. > Acces sis a desktop database, not capable of simultanious connections, > so > set it to 1 if it gets much traffic, you can put it a bit higher if > it's a > pretty low hit database. > > russ > > > -----Original Message----- > > I'm trying to figure out what might be a 'reasonable' setting > > for CFMX6.1 > > 'limit simultaneous requests'. > > > > It seems to me that with a 512Mb memory and 2.6GHz CPU > > running on NT4, > > with only one website in use (although there are many <spit> > > Access mdbs > > being accessed), that a figure of at least 100 would not be > > unreasonable. > > > > Any ideas/comments? > > > > Cheers > > Terry > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
