Hello,

My name is Ricardo, I live in Brazil and I am a beginner with SqlmanagerX and I am very happy to be glad this project.
My first steps and I'm still testing a few steps of the project.

Based on the example Sql4WD created a database with a table and this table has 4 fields with + or-12,000 entries

using the line of code below, I have the following results:

retcode = MySQL4WD: mySQLExec ( "SELECT * FROM cds ordrer BY id LIMIT 5000", 0)

Times results in my temporary table:
30,000 rec = 55 seconds
20,000 rec = 32 seconds
10,000 rec = 18 seconds
5000 rec = 12 seconds
1000 rec = 05 seconds

Is there any way to optimize for a more agile SELECT or optimize this query.

Could anyone help me in these first steps

Thank you for any tips

Best Regard
Ricardo