On 09-12-10 17:27, Vander Clock Stephane wrote: > no one have an idea how to do such query ?? > > thanks > stéphane > > On 12/8/2010 7:56 PM, Vander Clock Stephane wrote: >> Hello, >> >> on the table : >> >> CREATE TABLE HASH( >> ..... >> x5_y5>=<#randomnumber73> and >> x5_y5<=<#randomnumber73> + 20; >> >> because they takes very very lot of time (hourS) to return :( >> on other SGBD (like Firebird) with same amount of data >> they return immediatly ... > If you have another situation, wit same amount of data, which returns immedialty, than either situation is not the same, or you are making an error.
maybe creating indexes on more than one field, can speed up the query, but i cannot tell you on which fields, because i dont know the data _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
