RE: SELECT answer time

2001-08-23 Thread Don Read
On 23-Aug-2001 Filippo Galante wrote: > I´m converting an old DBF aplication to MySql an I´m having a very strange > problem. > When I first execute a query it takes from 12 to 30 seconds to have an > answer, after that it runs in about 2 or 3 seconds. Because it's got the index ( & maybe the re

SELECT answer time

2001-08-23 Thread Filippo Galante
I´m converting an old DBF aplication to MySql an I´m having a very strange problem. When I first execute a query it takes from 12 to 30 seconds to have an answer, after that it runs in about 2 or 3 seconds. It´s a very large file (ZipCodes) and I must seek by ZipCode, by State/City/Street (where