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 as fast as everyone says.
I have two tables:
parole (6 million rows, 10 field (id,word ......etc , all varchar 255, except id that is a number)) and
mega (200.000 rows and two field : id,word, id is number and word varchar),
So I create some index: two on parole: id_paroleidx and word_paroleidx and two on mega, id_megaidx and word_megaidx.
Then I do the the following query :
select parole.id, mega.id from parole,mega where mega.word=parole.word;
This query take 7 minutes to get all output.
The output is redirected to file to avoid terminal,
PRAGMAS ,default_cache_size 300000 and default_temp_store MEMORY, and synchronization is off.
The same table in mysql with the same index take 20 seconds to output all results.
This behaviour is the near the same on windows and on linux. With default PRAGMAS parameter sqlite performance are more slow.
Any ideas ? Thank a lot in advance Alex
