Monthly Archives: April 2010


Technical Talk on Notes

I used Logos4 during a class for taking Notes for the first time since importing all my old Libronix notes… I was not happy… It worked, but was sluggish… Time to do more research…

Turns out importing was the problem again… I removed all the notes I imported and performance picked up again… On looking on the Logos forums, other users can confirm my experience…

This data is also stored as SQLite database files like the highlighting data. This database is better with indexes than the highlighting one is, (I was able to do manual queries with decent times for returns of data) but it still needs work. SQLite is a good piece of software, so there must be something odd with the way Logos 4 is using it.

It looks like what happens when you let programmers design the database. This is not meant as a slam nor am I looking for a job. 😉 I do database administrator (DBA) work and manage programmers for a living and see this all the time. Programmers generally don’t make good DBAs. They know enough to make things work, but their database work just doesn’t scale well, just like what we are seeing here with highlighting and notes. A database specialist is need to craft efficient queries and design an effective database structure. In the case of notes, I think queries are being executed using features such as “LIKE” or “GLOB” that may force full table scans because they can’t use indexes, but can’t know for sure without access to the Logos source code.

These issues should be simple enough to fix, but will probably require rebuilding the databases from scratch, which will be another multi-hour process for most of us having problems. That is if and when Logos addresses them…


Highlighting

Highlighting matters to readers and even more so to studiers. Logos 4 has introduced some changes in the way highlighting works and thankfully has included the ability to craft custom pallets. What does that mean and how does it work? Read on…