Any specific syntax needed to work or can I call them like SQL stored procedures? Do you use CFQUERY or CFSTOREDPROC? I want to get all the data on this before I move a 400 meg DB file from the HoF server to my home system and back again. And that's just CF-Talk
At 04:01 PM 6/21/02, you wrote: >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 > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
