On Dec 19, 2005, at 8:32 AM, Teg wrote:
I notice a similar thing with my databases when they get to any decent size. it seems like the first time you access them, doing anything, there's a decent startup delay and then it's fast from that time forward. Someone mentioned OS disk cache and I wonder about the internal SQLite cache too.
Define "decent size". I've never seen any significant delay opening any SQLite database. But I don't have databases that are gigabytes big, so maybe I've just never run into the problem.