RE: FoxPro databases: does CF use indexes?
CF will access FoxPro efficiently, we do it all day every day. If you submit a poorly written query it will perform poorly, but if you write an optimized query it will fly. For example, we have an inventory table with an index defined as UPPER(stockno). I had a programmer write a query on his page for WHERE stockno = '#form.stockno#'. It would take FOREVER to run. When I looked at it and realized it wasn't using the index and had him change it to WHERE UPPER(stockno) = '#form.stockno#' the results were instant. In fact you could take his original query straight out of CF and execute it in FoxPro and while it was every bit as slow. As others have said, all CF does is pass the query off to the FoxPro ODBC driver you have installed on your server. It's up to that driver to insure the performance. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 12:55 PM To: CF-Talk Subject: RE: FoxPro databases: does CF use indexes? 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FoxPro databases: does CF use indexes?
not just the driver...the server as impacts on performance also. -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 13:35 To: CF-Talk Subject: RE: FoxPro databases: does CF use indexes? CF will access FoxPro efficiently, we do it all day every day. If you submit a poorly written query it will perform poorly, but if you write an optimized query it will fly. For example, we have an inventory table with an index defined as UPPER(stockno). I had a programmer write a query on his page for WHERE stockno = '#form.stockno#'. It would take FOREVER to run. When I looked at it and realized it wasn't using the index and had him change it to WHERE UPPER(stockno) = '#form.stockno#' the results were instant. In fact you could take his original query straight out of CF and execute it in FoxPro and while it was every bit as slow. As others have said, all CF does is pass the query off to the FoxPro ODBC driver you have installed on your server. It's up to that driver to insure the performance. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 12:55 PM To: CF-Talk Subject: RE: FoxPro databases: does CF use indexes? 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=subscribeforumid=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
Re: Foxpro databases: does CF use indexes?
Ed Gordon wrote: 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? That is not up to CF to decide but to the database drivers (Foxpro is a filebased desktop db, right?). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=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
RE: Foxpro databases: does CF use indexes?
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=subscribeforumid=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
