joins are slow ?

[Ruslan Zasukhin]

On 9/25/04 3:05 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> Next. What size of cache you use?
>> Make sure it is 10-20 MB.
> 
> I tried 5,10,20,100 Mb of cache. No change.
> 
> I tried with the db of example DELIVERED WITH VALENTINA (tables Person,
> Task).
> With approximately the same number of data and a not very precise
> clause (SELECT * FROM person,task WHERE byte_fld <10),
> it is very slow...

Hmm.

Please tell by STEPS this.
I want to repeat.

VERY DETAILED! 
    what example, how you create db,
    what tool you use for query.
    Which query you do.


> Requests with  a unique and not precise clause (>, <) are very slow.
> 
> How to correct it ?



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