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) usi

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) usin

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 a

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 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 me

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 o

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
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 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