Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > Background: Will 64 bit versions of SQLite buy us any significant > difference in performance? You need to have some benchmark code first, ideally in the form of a representative script to feed to the sqlite shell. That

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Jay A. Kreibich
On Mon, Sep 01, 2008 at 03:10:05PM -0400, [EMAIL PROTECTED] scratched on the wall: > Does anyone have any benchmarks to share that compare common SQLite > operations running under a 32 and 64 bit versions of SQLite? This > question is OS neutral so please feel to share your experience with 32 >

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Sherief N. Farouk
I can't speak for SQLite, but off of the top of my head, a 64-bit platform will give you enough virtual address space to memory map the files, which usually proves to be a win. I'd say go with the 64-bit systems and as much ram as you can afford. - Sherief > -Original Message- > From: