Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>1. I am accessing the data locally.
>>>>2. The total number of records is 7,127.
>>>>3. The speed is approximately 17 seconds with this data set.
>>>>
>>>
>>>Did you tried to delete tags all and add them one by one by adding a new condition? 17 sec. seems too long for me. It should be 1-3 sec. Did you try it on different machines?
>>>
>>>>>Did you access this table locally or through the network? What's the number of records in a table and what speed do you get?
>>>>>
>>
>><snip>
>>
>>The last thing I tried was to create a simple index which would return 20000 records. This test CDX contains no other indexes other that the one index. I ran a test on this one index and it still took 27+ seconds on my machine.
>
>I'm out of ideas :( Have you tried Walter's suggestion?
I tried that and it took about the same amount of time as the original SELECT command. Thanks for your ideas. We've clearly reached a limitation of what FoxPro can do.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement