I have a database on MySQL which I am building a front end application for in VFP. This database has 1.7 million records in it. If I query a record using the mySQL Query Browser, it takes 0.0173 seconds to display it. When I use the following VFP code:

PUBLIC gnconnhandle, namestoup
STORE SQLCONNECT('TestingPatient', 'myname', 'password') TO gnConnHandle
labstm = "select * from labtest1 where upi = 00103194"
SQLEXEC(gnconnhandle,labstm, "lab")
SQLDISCONNECT(gnconnhandle)
browse

it takes MUCH longer...like 10-15 secs. What I cannot understand is that if I run the same VFP code on the SAME upi number, it pops up instantly. Even if I close VFP and then reopen in a new session, it appears in a split second. If I try searching for a upi that I have never searched for before, it takes a long time again.

Why does this happen and how can I make the first search on a upi as fast as the subsequent searches on the same upi? The MySQL table has an index on upi....