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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4