of course, i agree
xbase needed indexes to work properly
Bob McConnell escribió:
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
---
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.com
