Recommendations for Bugzilla hardware

[Bradley Baetz]

On Wed, Oct 19, 2005 at 12:51:54PM -0700, Max Kanat-Alexander wrote:
> On Wed, 2005-10-19 at 09:59 +0800, byron wrote:
> > has anyone benchmarked mysql vs postgresql?
> 
> 	I did some very brief, somewhat crude testing just now on landfill.
> 
> 	Basically, I just ran a simple query over and over:
> 
> time ./buglist.cgi "resolution=---&order=bugs.bug_id" > /dev/null

Most of the time is going to be in the perl in that case. my testing (a
couple of years ago) was that mysql was faster for simple queries, but
anything involving joins (eg searched on longdesc) were a lot faster in
postgres due to its query planner. 1750 bugs will all be in RAM, though,
so the difference should be almost nothing

Bradley