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

--- 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/