dolik.rce Messages: 1789 Registered: August 2008 Location: Czech Republic
Ultimate Contributor
forlano wrote on Sat, 29 December 2012 15:35
Edit: just now I checked better and I discovered that the query do nothing ... there should be some syntax error in the query somewhere... investigating
Exactly what I thought when I saw that the times are so much faster now, "That looks to good to be true" I probably made som mistake in the code or there is something I missed about sqlite syntax, I'm no expert either
You should probably check the queries. Some time ago in another thread, I posted a very simple sqlite console written in U++. You can use that or some other tools (e.g. sqlitebrowser or sqliteman) to inspect the contents of the database and to easily test the queries.