Re: ubh3 + MySQL 4.1.x, default storage engine "gothca"

Hi,

I am gonna try to port the SQL to DB2 UDB on Linux, just curious how 
it performs versus MySQL. I would like to see the patches that were 
necessary for PostgreSQL - but I can't find them. Could they be 
reposted please ?  I am interested in the patch for Benchmark::Timer 
too - just to be sure I measure in the same way as Ben did.

Tia,
Herman



--- In [email protected], "Ben" <synaptic_axon@y...> wrote:
> 
> --- In [email protected], "gerardlanois" <gerardlanois@y...> 
wrote:
> > Needless to say, this causes horrific database performance.  I
> > noticed I was getting about 6 inserts per second in ubhdb.
> > 
> > With MyISAM, ubhdb is doing about 192 inserts per second.  Ahhhh,
> > much better.
> 
> Just out of curiousity, what kind of hardware are you using?  I ask
> because I am getting about 312 inserts/second (the multipart, 
header,
> and xref_header inserts in ubhdb) using the PostgreSQL 7.4 patches 
I
> made a while ago.  My PostgreSQL installation is actually many
> versions out of date (8.0 has been released for a while now and has
> good Windows support) and has not been tuned (out of the box
> postgresql.conf).
> 
> I'm using Benchmark::Timer around each iteration of the loop in
> ubhdb::add_articles and around the multipart query.
> 
> 578366 trials of process article (3,980s total), 6.883ms/trial (2
> inserts per trial)
> 
> 84327 trials of multipart (272.331s total), 3.229ms/trial (1 insert
> per trial)
> 
> 578366*2+84327=1241059/3980~=312
> 
> There are several selects happening there too, the overhead of the
> benchmark code, and some very slight overhead from constraint
> triggers, functions, and indexes.
> 
> I'm curious about the performance of modern MySQL databases in
> comparison.  I haven't used it heavily since late 3.x/early 4.x.  
> 
> My specs are:
>   900MHz Athlon tbird
>   768MB
>   Linux 2.4.27
>   ext2 @ 85% utilization
>   IBM-DTLA-307045 46.1GB 7200rpm 2MB buffer
>   
> If you don't care or don't have time, I would understand.
> 
> Ben





 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ubh/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/