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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to