We've used them. They're very, very efficient - while I haven't compared between indexed and non-indexed fields, they lower resource usage with or without indexes.
We took one query from 30 seconds to 600 ms... Ian -----Original Message----- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 12:39 PM To: CF-Talk Subject: Access 2k Stored Procedures Has anyone used Access 2000 stored procedures with CF and have they shown to be more efficient when it comes to indexes? I have a few huge Access 2k DBs and while some fields are indexed, it does not seem to be help much. If a stored procedure will make better use of the indexes and lower the resource usage, it'll help greatly. Thanks Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
