On 21 Oct 2009, at 2:47pm, Unabashed wrote: > I'm using SQLite as DB in my application. My problem consists of two > aspects. First , it works great, but on large data SELECTs are very > slow > (10-20s!). Queries are in one transaction. My table structure is: > CREATE TABLE mgWords ( > id INTEGER PRIMARY KEY AUTOINCREMENT, > id_norm INTEGER, > word TEXT, > wform TEXT) > It seems, that the problem is in sql. How to optimize table to have > fast > selects?
Add the appropriate indexes to your database. If you would like us to suggest an appropriate index, please supply examples of your SELECT commands. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
