first cursor very very slow when it is sorted

[Olivier]

Le 10 janv. 05, à 12:56, Ruslan Zasukhin a écrit :

> Long. This again can be result of not cached INDEXES.

after several tests, this SQL request take 1 second with 110 000 little 
records (4 strings, 1 boolean) :

cur=new vcursor(DB,"SELECT recid,string1, string2, string3, boolean1 
FROM Table ",2,3,2)



this SQL request (on same 110 000 records) take .... 1 minute, 1 MINUTE 
!!! :

  cur=new vcursor(DB,"SELECT recid,string1, string2, string3, boolean1 
FROM Table ORDER BY string1",2,3,2)

string1 is indexed !
cache : 50 Mb

This query put one minute THE FIRST TIME.
If I relaunch the SAME query then, it will put ONLY one second.

The sorting by "ORDER BY" is thus very very long.

olivier
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 770 bytes
Desc: not available
Url : http://lists.macserve.net/pipermail/valentina-beta/attachments/20050111/a28a7533/attachment.bin