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]
