> Was wondering what file size limits Access2000 DB have? I believe that the maximum file size is 2 Gb. I've actually seen files nearly that large being used in CF applications (1.8 Gb or so). Interestingly enough, the file size by itself doesn't necessarily make that much of a performance difference, if you have a fast enough disk subsystem and enough memory (4+ Gb or so). The number of concurrent users seem to make more of a difference.
In one case, a file about that size was being used as a Client variable repository. The tables themselves only had a couple of hundred records, but since Access databases grow but don't shrink, the thing just kept getting larger! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists