It's one of those things u have to test really, there is no surefire answer with access, it's whatever works for your situation. But 5 is a max really.
Russ > -----Original Message----- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: 23 January 2004 15:18 > To: [EMAIL PROTECTED] > Subject: RE: FW: [ cf-dev ] CF settings > > > Tell me about it! > > No, even I'm not *that* dumb (though, having got involved in this > project, maybe I am!). That's overall. > > But if I don't go into each and every datasource and change > the connection > limit from none to (say) 5, it may well fall over frequently, > as there > will be no brake on access to individual mdbs. I assume I'm > making the > right decision here? > > Cheers > Terry > > ----------Original Message--------- > > > 350 databases :-O gobsmacked. > > > > > > You don't mean u have set 100 simultanious connections in > the DSN for > > 1 access database do you? Cozz it will fall over and die > horribly if > > you have. If you mean total connections for the server, > then this is > > totally down to > > the power of your server, lots of memory helps. > > When you set a low number of connections (i.e 1) coldfusion > queues up > > the > > requests and processes them one at a time when the database is free. > > > > Russ Michaels > > Macromedia/Allaire Certified ColdFusion Developer > > > > CFDeveloper > > The free resource and community for ColdFusion developer. > > http://www.cfdeveloper.co.uk > > > > Join the CFDeveloper discussion lists. > > To subscribe send an e-mail to [EMAIL PROTECTED] > > > > > > > > > -----Original Message----- > > > From: Terry Riley [mailto:[EMAIL PROTECTED] > > > Sent: 23 January 2004 13:02 > > > To: [EMAIL PROTECTED] > > > Subject: Re: FW: [ cf-dev ] CF settings > > > > > > > > > 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? > > > > -- > ** 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] > -- ** 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]
