You sqlite file actually looks fine ... I changed your word column to be a VARCHAR, and then compacted it and it reduced the file size by half, but I guess that is not necessary.
Perhaps you should post the code that is running slowly as I do not have any more ideas.
Also, I do _not_ think you should combine multiple languages into one table. You could combine them into one sqlite file but many tables if you wanted, or just keep it as separate sqlite files.
|
