For a paging style query, row_num windowing function is more efficient. Postgres supports it atleast from 8.x version I think.

And my own shameless plug: http://code.google.com/p/ifreebudget-android/ http://sourceforge.net/projects/ifreebudget/

Agreed. I was not disciplined when the project began. Going back and javadoc'ing the whole code base is non easy now. Anyway almost half is gui layout code, no use adding javadocs for that. I wish I was more careful from the beginning.

I am looking for volunteers to help me out with my open source project. Search for it on sourceforge using my nickname. It is java and even has android port if you are interested in programming for that platform. The project field is kind of "unsexy" so I am having trouble finding volunteers to work on it, or maybe my code is so messy that it is scaring people off :)