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: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Monday, September 01, 2008 3:10 PM > To: General Discussion of SQLite Database > Subject: [sqlite] Difference in performance between 32 and 64 bit > versions of SQLite? > > 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 > and 64 bit versions of Windows or Linux. > > Background: Will 64 bit versions of SQLite buy us any significant > difference in performance? I may have a chance to get our department 64 > bit AMD workstations with 8G, but I need to justify the extra cost > against a reasonable guess at what the performance improvement may be > against an equivalent 32 bit AMD 4G workstation. These workstations > will > be processing very large text based log files (> 16G each). We will be > using Python 2.52 as our SQLite scripting tool. > > Thank you, > Malcolm > _______________________________________________ > sqlite-users mailing list > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users