Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-30 Thread Rahul S. Johari
On Nov 30, 2009, at 11:41 AM, Bob McConnell wrote: From: Rahul S. Johari On Nov 30, 2009, at 11:07 AM, Bob McConnell wrote: From: news even though the dbf has 10K records Fox can't spend "minutes" to found a match by the way, its very strange to have 35 columns in a table/dbf or whatever.

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-30 Thread Rahul S. Johari
On Nov 30, 2009, at 11:07 AM, Bob McConnell wrote: From: news even though the dbf has 10K records Fox can't spend "minutes" to found a match by the way, its very strange to have 35 columns in a table/dbf or whatever pay attention to the comment of Ashley in Fox, you should: SELECT direc

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-30 Thread Hernán
of course, i agree xbase needed indexes to work properly Bob McConnell escribió: From: news even though the dbf has 10K records Fox can't spend "minutes" to found a match by the way, its very strange to have 35 columns in a table/dbf or whatever pay attention to the comment of Ashley

RE: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-30 Thread Bob McConnell
From: news > even though the dbf has 10K records > Fox can't spend "minutes" to found a match > by the way, its very strange > to have 35 columns in a table/dbf or whatever > > pay attention to the comment of Ashley > in Fox, you should: > > SELECT directory > INDEX on phone_number to idx_di

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Back in 1996 FoxPro was multi-platform. The last FoxPro version released for Mac was Visual FoxPro 3.0b (1996). After that Microsoft bought FoxPro and Mac Support/Development was cut off. As of now, there are NO known ODBC Drivers for FoxPro for the Mac Platform. So that aside ... back to O

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
uhh, i don't know (time ago Fox was multi-platform unix/mac/dos) did you found that on the web? Rahul S. Johari escribió: Keyser, It gets better -- I'm on a Mac OS X (Leopard)!! As far as I know, there isn't a VisualFoxPro ODBC Driver for Mac OS X. On Nov 24, 2009, at 10:11 AM, keyser s

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Keyser, It gets better -- I'm on a Mac OS X (Leopard)!! As far as I know, there isn't a VisualFoxPro ODBC Driver for Mac OS X. On Nov 24, 2009, at 10:11 AM, keyser soze wrote: Rahul, my friend i found this in a first search perhaps it be helpful http://www.yinfor.com/blog/archives/2008/0

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
I do believe that what I'm doing is scanning the foxpro dbase row by row to get the match ... which is why it's returning the results very slow. But I don't know if there's any other way to do this. Basically the FoxPro DBF has 75,000 records and I have to search for the one row which has

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
Rahul, my friend i found this in a first search perhaps it be helpful http://www.yinfor.com/blog/archives/2008/01/php_connect_dbf_file.html Rahul S. Johari escribió: I do believe that what I'm doing is scanning the foxpro dbase row by row to get the match ... which is why it's returning the r

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
i will try to help you but think i'm old in Fox but new in php and sadly never used php+fox so, reading your code i see you are scanning the whole dbf file from php Fox cant help you in this way if there is not another option for scan a dbf the row by row method is very slow Rahul S. Johari

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Your post definitely gives me hope. It's possible I'm doing something wrong! I definitely have the foxpro database indexed. I use this FoxPro command ... INDEX ON PHONE TAG PHONE I do have a .CDX file present for the Database and if I MODIFY STRUCTURE and I can see the INDEX present on PHO

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
even though the dbf has 10K records Fox can't spend "minutes" to found a match by the way, its very strange to have 35 columns in a table/dbf or whatever pay attention to the comment of Ashley in Fox, you should: SELECT directory INDEX on phone_number to idx_directory_phone - or - INDEX on p