> You really shouldn't use MS Access with Cold Fusion... (it's probably a
> given that this is true, but with California State budget cuts, it'll be a
> while before we save up enough pennies to buy anything better)

What about MySQL?  It's still Free to my knowledge...  You may want to look
into this.

> If you do use MS Access, you should set CF's threads to 1:  T/F?

No, we keep our threads normal...  Never had a problem.

> If you do use MS Access, and set the threads > 1, you risk corrupting your
> DB:  T/F?

Not that I know of.  There is a performance hit due to the fact that Access
uses table level locking during inserts/updates.  Also, it doesn't shrink
very well, so you can end up with some extremely bloated DB's over time
(compact and repair when you can...) but otherwise, it functions as
advertised.

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]
http://www.spectrumastro.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to