Hi. I know Access is supposed to break down if hit with too many requests at once. Using Access 2000, what would be a good number to limit the simultaneous connections to the database? I've been setting them at 5. I don't expect there's going to major traffic at any of the sites. A couple GB a month or so. If there are 10-20 people on the site at once, since most queries are going to run in way under a second, there shouldn't be but a second or 2 delay at the most, eh? Also, if a query is cached, does it make a connection to the DB at all, or is it totally in RAM? Thanks. Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
