When I started working here. They were using an Access database to handle a very high traffic intranet application. I was amazed Access was holding up so well.
I would recommend Compacting and repairing the database every once and a while. Also there is a script that you can run to re-start the CF service every night at 2am that helps with Access databases and memory issues. Cycle the ColdFusion services each night using the \cfusion\bin\cycle.bat file. http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540&Method=Full -----Original Message----- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 2:36 PM To: CF-Talk Subject: CF and Access I am making a quick site that will allow users to register and make football picks each week. It has an admin section that will allow all the necessary data be input. I am using an Access DB for this site. If I expect 100-200 users, can the Access DB handle this? Do I need to use CFLOCK around all queries? Thanks for your help! Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
