Re: [sqlite] Inner Join Performance Issue

5 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Inner Join Performance Issue I just ran EXPLAIN, how can I tell if the Indexes are used? I just read, that with an operator "like '%a%'" SQLite won't use an Index. Is this the case? Thanks Ralf > -Ursprüngliche N

Re: [sqlite] Inner Join Performance Issue

On 22 Oct 2009, at 9:55pm, Ralf wrote: > I just read, that with an operator "like '%a%'" SQLite won't use an > Index. > Is this the case? The '%' at the beginning of that operand indicates that the first character of the string can be anything. An index is of no use if you don't know

Re: [sqlite] Inner Join Performance Issue

ite.org] Im Auftrag von John Crenshaw > Gesendet: Donnerstag, 22. Oktober 2009 05:53 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Inner Join Performance Issue > > Try to EXPLAIN the query and verify that the index is actually used. > There are a lot of

Re: [sqlite] Inner Join Performance Issue

, 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 "se

[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