[PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean it's taking minutes. When the dbase had 10,000 records ... search

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

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 08:40 -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean it's

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

2009-11-24 Thread Rahul S. Johari
On Nov 24, 2009, at 8:59 AM, Ashley Sheridan wrote: On Tue, 2009-11-24 at 08:40 -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is

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

2009-11-24 Thread Olav
Ashley Sheridan wrote: I would assume that any indexes created on any tables would be referenced automatically by the dbms and wouldn't need to be explicitly referenced from within PHP. This is dBase (.dbf) he is asking about. There is no such thing as a DBMS in dBase. The program / driver

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

2009-11-24 Thread Rahul S. Johari
Quite right. Unfortunately there doesn't seem to be any available ODBC Drivers for FoxPro available for Mac OS X either!! I'm hitting a brick wall no matter what direction I take. On Nov 24, 2009, at 12:22 PM, Olav wrote: Ashley Sheridan wrote: I would assume that any indexes created

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

2009-11-24 Thread Paul M Foster
On Tue, Nov 24, 2009 at 08:40:09AM -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean

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

2009-11-24 Thread Olav
Rahul S. Johari wrote: Quite right. Unfortunately there doesn't seem to be any available ODBC Drivers for FoxPro available for Mac OS X either!! I'm hitting a brick wall no matter what direction I take. Convert to SQLite and don't look back ;) Unless your DBF files are still in use in

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

2009-11-24 Thread Rahul S. Johari
Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using PHP which is running on an Apache Web Server on Mac OS X. I

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

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 12:59 -0500, Rahul S. Johari wrote: Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using

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

2009-11-24 Thread Paul M Foster
On Tue, Nov 24, 2009 at 12:59:35PM -0500, Rahul S. Johari wrote: Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using