Hi, Jeun
<snip>
>The problem that I am having is that I use a lot seeks in my code to retrieve data to the user at VFP's breakneck speed but MySQL and I am assuming that this applies to all database servers that conform to some SQL standard, the indexes are structured as FIELD1,FIELD2,... whereas VFP indexes are expression based.
<snip>
The problem is that you are trying to apply record-based logic instead of result-based logic. In any relational database you don't access records directly (as with SEEK), but instead, you ask the engine what resultset you need, and the database takes care about optimizing the query.
In other words, you don't SEEK/SCAN records anymore, and perform SELECT statements instead.
Of course, this implies a huge rewrite of most your code if you have being using SEEK/SCAN.
Tell me if I can help you in this process.
Best luck,