Re: Re: dbase_get_record_with_names; Very slow search!!!
| From: | Hernán | Date: | Mon, 30 Nov 2009 16:17:01 +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-300157@lists.php.net to get a copy of this message | ||
of course, i agree
xbase needed indexes to work properly
Bob McConnell escribió:
From: news--- avast! Antivirus: Outbound message clean. Virus Database (VPS): 091130-0, 30/11/2009 Tested on: 30/11/2009 01:17:03 p.m. avast! - copyright (c) 1988-2009 ALWIL Software. http://www.avast.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