> Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use?
OK, here's a simple rule of thumb: mySQL (or msSQL <g>) is a Server app, so it should be used on servers Access is a Desktop app, so it should be used on a desktop As long as you can GUARANTEE that the traffic is very low, then Access will do, but it has HUGE Jet Engine problems, and horrible memory leaks - DO NOT use it in a live environment that you expect to get some real traffic to (Intranet or Internet) It's probably better to use mySQL anyways as if you ever have to upgrade the number of users, then you don't have to do anything - with Access you'd have to re-write to get it working with a real database engine once you increase the number of users Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ 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
