Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL searches
Message
 
 
To
13/10/2005 14:45:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01058817
Message ID:
01058821
Views:
8
Which part takes long, connecting to mySQL or executing query?

>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....
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform