joins are slow ?

olivier vidal_olivier at yahoo.fr
Sat Sep 25 14:17:53 CDT 2004


example database of valentina :

- 2 tables Person,task:

-200 000 records.

-cache 20 Mo

-byte_fld indexed

request :
"SELECT * FROM person,task WHERE byte-fld <10"
result : 19 SECONDS !! with a BYTE FIELD INDEXED.

(RB 5.5.3 - Valentina 1.90 - Powerbook 400Mhz X 10.3.3 HD 4200 trs/mn 
384 Mo RAM)

it is normal ?
Or there is a problem with Valentina?
Or it is my computer? (But I tried with a PC / WINDOWS XP:  same 
problem) 



More information about the Valentina mailing list