Re: Re: dbase_get_record_with_names; Very slow search!!!
| From: | Rahul S. Johari | Date: | Mon, 30 Nov 2009 16:35:11 +0000 |
| Subject: | Re: Re: dbase_get_record_with_names; Very slow search!!! | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-300158@lists.php.net to get a copy of this message | ||
On Nov 30, 2009, at 11:07 AM, Bob McConnell wrote:
From: newsThat 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? --- Rahul Sitaram Johari Founder, Internet Architects Group, Inc. [Email] sleepwalker@rahulsjohari.com [Web] http://www.rahulsjohari.comeven 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