General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only