> 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. >
same situation (same amount of data) but on other SGBD like Firebird. the result return imediatly. on sqlite3 it's take hours :( > 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 > i thing that 5 index is quite enalf because the number of rows returning by just the indexed column is zero _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
