My memory of using VFP databases with CF was not a good one and seem to remember running into the same issues. I then turned to getting the data into SQL. I realize that may not be an option for you. You might want to check some ASP forums and see if that have any threads on using these databases. Theoretically it is the same, ODBC passing the query along to the DB. I also seem to remember queries doing a number on the server resources.
Dan -----Original Message----- From: Jack Ince [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:38 AM To: CF-Talk Subject: RE: Foxpro databases: does CF use indexes? Foxpro is independent of CF. When you submit you cfquery all data gathering is passed off to Foxpro. From there Foxpro will proceed just like it was a Foxpro request, and will use any index it can. I assume that your management has upgraded to Visual FP if they are so concerned about the speed. -----Original Message----- From: Ed Gordon [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:22 AM To: CF-Talk Subject: Foxpro databases: does CF use indexes? Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell? How could I *prove to management* that it indeed is using them? If not, can I explicitly use them? How? Thanks in advance for your help... Ed Gordon --- Old so Soon, Smart so Late, When I'm Learning, ... Life is Great! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4