joins are slow ?

olivier vidal_olivier at yahoo.fr
Sat Sep 25 15:53:50 CDT 2004


>>
> Yes, in app and visql.
> in app, We win 4 seconds, it is always long. In ViSQL, no change.
>

In my app with 1 table with 378 000 records (database : 125 Mo (data 50 
Mo, index 75 Mo)) , The same operation puts 1.66 sec in viSQL from the 
first attempt.
0.51 sec from the second!
Ten - fifteen times as quickly without join. (19 sec with join)



More information about the Valentina mailing list