Well, just to update anyone who may be having problems with timeouts from Access dbs. A little over a week ago I was averaging around 150 timeout errors in my CF logs per day (yuk). I spent several days trying different approaches, and set up a Task to restart CF at 4 AM every day. These are my settings now after playing with them for a few days. Page Timeout=600, Buffer Size = 0 as Allaire recommends in my Access datasources. All my Access datasources were already set up like that with maximum 1 connection. Limit simultaneous requests to 35 (2 CPUs). Allaire recommends 5-7 per CPU, but I believe their example must be with a single datasource on the machine. Template Cache Size: 24 MB I have 1 GB of RAM, so that shouldn't be too much. It was at the default of 2 MB, so this really needed bumped up anyway. Anyway, I'm happy to report that as of midnight tonight it's been 1 full week without a single timeout error in my logs. Happy Happy Joy Joy Also, I've convinced my Colo provider to let me bring in a 1U rackmount at no additional monthly fee and am looking at a nice Dell 1550. Almost have enough saved to get me 512 K or 1 GB of RAM with a single 1GZ CPU so I only need one Processor license for SQL 2000 and an 18 GB RAID 1 setup. Be good to go soon. :-D -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
