re: Re[2]: [sqlite] multiple Db's and journal file time hit?

te-users@sqlite.org> Subject: Re[2]: [sqlite] multiple Db's and journal file time hit? Hello sales, What are you using for a data structure? I regularly have literally millions of hashed data structures in memory without encountering this. If it's windows, I know exactly what it is though, wi

Re[2]: [sqlite] multiple Db's and journal file time hit?

Hello drh, I'll try to characterize what I see. I'm running bare-backed here, no firewall or virus scanner (though I'm protected from the internet by a hardware firewall). Some of my databases are pushing 10gig but, I see it on smaller ones too, or at least I think I see it. C Monday, December

Re[2]: [sqlite] multiple Db's and journal file time hit?

Hello sales, What are you using for a data structure? I regularly have literally millions of hashed data structures in memory without encountering this. If it's windows, I know exactly what it is though, windows pages things out on a whim so, if you're not constantly touching your data

Re: Re[2]: [sqlite] multiple Db's and journal file time hit?

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

Re[2]: [sqlite] multiple Db's and journal file time hit?

Hello sales, 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