Re: [sqlite] problem with sqlite velocity the revenge

2004-09-20 Thread Dennis Cote
Kurt Welgehausen wrote: >> ... only the first index is opened ... > > That's right. SQLite uses only one index, and it doesn't keep > statistics, so it may pick the wrong index if it has to choose. > Try forcing it to use the other index by dropping the one that > it's using now. > > Changing 'tab

Re: [sqlite] problem with sqlite velocity the revenge

2004-09-20 Thread Kurt Welgehausen
> ... only the first index is opened ... That's right. SQLite uses only one index, and it doesn't keep statistics, so it may pick the wrong index if it has to choose. Try forcing it to use the other index by dropping the one that it's using now. Changing 'table1, table2 where' to 'table1 join ta

Re: [sqlite] problem with sqlite velocity the revenge

2004-09-20 Thread Alessandro BONVICINI
Hi , just to give you other info here is the output of the explain command C:\sviluppo\sqlite>sqlite.exe ex2 SQLite version 2.8.15 Enter ".help" for instructions sqlite> explain select parole.id,mega.id from parole JOIN mega ON mega.word=parole.word; 0|ColumnName|0|0|parole.id 1|ColumnName|1|1|m

Re: [sqlite] problem with sqlite velocity

2004-09-20 Thread Alessandro BONVICINI
Hi, thank for your response , I tired your suggestion but results where nearly the same . Here is the schema ouput sqlite> .schema CREATE TABLE "Mega"("ID" integer,"word" varchar(255)); CREATE TABLE "parole"("ID" integer,"file" varchar(255),"word" varchar (255),"tag" varchar(255),"lemma" varchar(2

Re: [sqlite] problem with sqlite velocity

2004-09-20 Thread Paolo Vernazza
alessandro bonvicini wrote: Hi all, I ask you an help because I don't understand what I am doing wrong with sqlite. First of all,anyway, I would like to thanks all of you for this software. Now I have some problem but I only need to understand where are my errors and I am sure that sqlite will be