Parcourir ce sujet :
1 Utilisateur(s) anonymes
First steps, first impressions |
||
|---|---|---|
|
Nouveau
Inscrit:
2005/1/11 16:16 Messages:
2
![]() |
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
Posté le : 3/12 4:13
|
|
Transférer
|
||
| Sujet | Auteurs | Dernières réponses |
|---|---|---|
| |
Ricardo | 3/12 4:13 |
| |
Firetox | 3/12 8:06 |
| |
Ricardo | 3/17 18:29 |
| |
Firetox | 3/17 18:36 |
















Transférer

