17
Sep
So yes, another step back in the Krecipes usability. SQLite is nice, easy to install, easy to code... but in two (or 3) words: "it's crap". Slower than a cow trying to climb up a ladder.
It's convenient when the lists are small and no strange queries are done, but give it a bit of search work, and it's useless. MySQL could do a query over 3000 recipes in 0.12s and took SQLite 1 minute to complete the same thing.... I can't say that's useful.
Somebody will say that having 3000 recipes is not usual... Well it is by other recipe tool users. Those 3000 recipes were imported just from a single file.
I'm now thinking of using embedded MySQL, but hey, distros like Mdk forget about this tiny library that should be included by default. Why???
If I can't solve this stuff... well, krecipes has its days counted. Well, at least for moms that do not know about passwords and usernames.
- uga's blog
- Login or register to post comments
- 1566 reads
Syndicate Blogs
Comments
Valentina database
You can look on Valentina Database.
http://www.paradigmasoft.com.
Note Testimonials page: http://paradigmasoft.com/en/testimonials
People say very impressive things about its speed
comparing to MySQL, Access, SqlLite...
joins
Sql can join 2 tables in 2 ways:
1) select bla from a, b where a.id = b.id and ....
2) select bla from a, (select id from b where seq=1) b where a.id = b.id and...
The second one is faster when the 2 tables get bigger.
This is because in the first case the 2 whole tables are loaded into memory and then joined, after which the irrelevant rows are removed.
The second first removed lots of rows from table B before it joins. Hence a smaller amount of data to move around.
DBs like oracle (and probably MySQL) will make that optimization step in their preprocess step. I'm not sure sqllite will.
You might want to try and see if that makes a difference.
Thanks!
I'll check that.
>For example, try doing a tra
>For example, try doing a transaction around your queries.
I'll look at that.
>Also, it is kinda slow if what you need are fulltext searches.
In this case it's just crosstable ID comparisons, and yes, I have almost no text searches except when completely necessary.
>You may also consider just using Qt’s database classes, and let the >user choose the backend.
I'm using those classes, but unfortunately they're not complete enough do do everything without going down to the direct DB calls.
I'm actually using qsqlite for SQLite (very nice interface indeed) and QSQl for MySQL.
Thanks for the suggestions