> Should I put named locks around database queries or should > the database engine (Access2000)? I have heard the Access > sometimes has indexing issues and I was curious if anyone > out their had experience with locks reducing the likelihood > of an indexing issue.
You should only lock for updating Application, Session and Server variables If you are putting the query into one of those scopes, load it into a Variables scope query first, then copy it to the other scope - a LOT quicker 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. ********************************************************************** ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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