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