Try to EXPLAIN the query and verify that the index is actually used. There are a lot of reasons why this query would probably NOT be using the index.
John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ralf Sent: Wednesday, October 21, 2009 5:50 PM To: 'General Discussion of SQLite Database' Subject: [sqlite] Inner Join Performance Issue Hello Forum, [>> ] I have a select that joins 15 Tables the where clause consist of 8 like relations (all fields are indexed), this is to implement a sort of "search engine". The performance is awful. It takes around 10sec. Is this how it should be or is there anything I can do? If you need more infos pls. let me know Thx Ralf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
