> Select > H1.ID > from > HASH1 H1 > where > x1_y1 BETWEEN min11 AND max11 AND > x1_y2 BETWEEN min12 AND max12 AND > x1_y3 BETWEEN min13 AND max13 AND > x1_y4 BETWEEN min14 AND max14 AND > x1_y5 BETWEEN min15 AND max15; > >
no it's not work at all !! without an rtree index the speed is a total disaster (several minutes) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users