first cursor very very slow when it is sorted

[Ruslan Zasukhin]

On 1/11/05 9:25 AM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

> 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.

Oliver, first time Valentina build special index for sorting.
I again say, INDEXES are NOT cached now. This is a reason.

Do not test for now big number of records.
I think on this week we will make indexed to be cached.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------