Re: any proper benchmark scripts?

Thomas Good wrote:
>
> On 18 Apr 2001, Clayton Cottingham aka drfrog wrote:
>
> > i will recomp both the newest postgresql and mysql
> > not using any optimizing techs at all i'll post the
> > config scripts i use
>
> Hiya Clayton,
>
> Try it with a few hundred thousand tuples in a good size table with
> say 300 users banging on the box. MySQL is a nice substitute for
> Access but that's about it.
>

if you check the script youll see its fairly cool how they set it up

> Not to mention missing features: views and foreign keys for
> example...and have a look at the API...yuck. I always hear people
> complain (MySQL fans) about Pg not having DROP COLUMN in its SQL
> implementation. To me a VIEW is slightly more important. ;-)
>

yes all that was tested was inserts and selects

check my prev post if you check out that thread on modperl
youlll see why these where not included

they were testing hashes versus Storable.pm versus postgres versus
flatfile

> (Trying hard not to be obnoxious here but failing. Comparing MySQL
> to Pg is like comparing windows to BSD...and I just can't apologise
> for calling it like I see it!)

i agree

>
> Cheers!
> Tom (the most obnoxious man in Staten Island?)
>