Re: Re: dbase_get_record_with_names; Very slow search!!!

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.... pay attention to the comment of Ashley in Fox, you should: SELECT directory INDEX on phone_number to idx_directory_phone - or - INDEX on phone_number tag phone of cdx_directory i worked with Fox with dbfs of 2 millions of records and the speed is amazing -- using indexes of course!

It has been a long time since I worked with either FoxPro or dBase, but IIRC, both required you to explicitly create any indexes they might need. They don't have query analyzers like Postgres, MySQL and other modern DBMS engines. Bob McConnell

That is correct! But in my case - I DO indeed have Indexes created manually. FoxPro created .CDX files for Indexes. The problem is - does

PHP use those indexes?

And the secondary question is whether you have enough memory to 'permanently' cache those indexes? They don't improve performance very much unless they are kept in local memory all the time. The only way to fix this is to move to a real DBMS engine. Bob McConnell

Well that might be a problem. The indexes, along with the files, are stored on the network and they are accessed over the network, not locally. Although to be fair; I have tried using a copy of the DBF & it's Index File (CDX) locally and it didn't make any difference to the search. Either way, it all points in the same direction ... using a modern DBMS. It's just a problem on our end because all our customer data is in FoxPro databases and all the other applications are written for those FoxPro databases. --- Rahul Sitaram Johari Founder, Internet Architects Group, Inc. [Email] sleepwalker@rahulsjohari.com [Web] http://www.rahulsjohari.com