Обсуждение: database contest in c't (German IT magazine)

Поиск
Список
Период
Сортировка

database contest in c't (German IT magazine)

От
Markus Schiltknecht
Дата:
Hi,

in the current edition of the german computer magazine c't the results
of the database contest, which they announced last year, has finally
been published. It was based on a very simple DVD-Store web application
from Dell. [1]

Back then I spent some time modifying the original php5 application to
use PostgreSQL. I've written some stored procedures in C and optimized
the schema at obvious places. I've been short on time, though, and
couldn't do everything I wished to do. Most importantly connection
pooling didn't seem to make it into the final entry I have submitted. :-(

That might be one reason for the disappointing performance result: last
place, just before the disqualified entries.  The performance trophy
(once again) has gone to the MySQL Benchmark Team... [2]

With that result I fear I did a disservice to PostgreSQL. Once again it
seems to be just slower than MySQL. I'm sorry for that. Especially
because other strengths of PostgreSQL didn't get mentioned.

OTOH I at least hacked up something. My entry was the only counting one
using PostgreSQL - which is surprising and disappointing me. (The only
other PosgreSQL entry from Alvar C.H. Freude unfortunately got
disqualified because it was sent in too late [3]). Didn't the PostgreSQL
community know about that contest? IMHO it would have been  worthwhile
to start a community project and submit an entry. Just to get rid of
that 'too-slow'-image PostgreSQL still has.

At least I have learned: next time I'll try to start a community project
for such a contest!

Regards

Markus



[1]: Read more about it on http://www.ctmagazin.de/dbcontest (german,
there are english translations of the contest rules... somewhere...)

[2]: My solution (PHP5/PostgreSQL 8.1) got 120 opm (operations per
minute? Dunno anymore what that meant exactly), the best PHP5/MySQL
solution got 3664 opm. Another interesting one (IMO) was MonetDB with
1833 opm. The Java/DB2 Express one got 1537 opm, Java/Oracle 10g Express
1412 opm...

[3]: I'm quite sure Alvar's entry would have performed much better than
mine. AFAICT he has written a quite well optimized apache/mod_perl/pgsql
solution.

Re: database contest in c't (German IT magazine)

От
Michael Dean
Дата:
Markus Schiltknecht wrote:

> Hi,
>
> in the current edition of the german computer magazine c't the results
> of the database contest, which they announced last year, has finally
> been published. It was based on a very simple DVD-Store web
> application from Dell. [1]
>
> Back then I spent some time modifying the original php5 application to
> use PostgreSQL. I've written some stored procedures in C and optimized
> the schema at obvious places. I've been short on time, though, and
> couldn't do everything I wished to do. Most importantly connection
> pooling didn't seem to make it into the final entry I have submitted. :-(
>
> That might be one reason for the disappointing performance result:
> last place, just before the disqualified entries.  The performance
> trophy (once again) has gone to the MySQL Benchmark Team... [2]
>
> With that result I fear I did a disservice to PostgreSQL. Once again
> it seems to be just slower than MySQL. I'm sorry for that. Especially
> because other strengths of PostgreSQL didn't get mentioned.
>
> OTOH I at least hacked up something. My entry was the only counting
> one using PostgreSQL - which is surprising and disappointing me. (The
> only other PosgreSQL entry from Alvar C.H. Freude unfortunately got
> disqualified because it was sent in too late [3]). Didn't the
> PostgreSQL community know about that contest? IMHO it would have been
> worthwhile to start a community project and submit an entry. Just to
> get rid of that 'too-slow'-image PostgreSQL still has.
>
> At least I have learned: next time I'll try to start a community
> project for such a contest!
>
> Regards
>
> Markus
>
>
>
> [1]: Read more about it on http://www.ctmagazin.de/dbcontest (german,
> there are english translations of the contest rules... somewhere...)
>
> [2]: My solution (PHP5/PostgreSQL 8.1) got 120 opm (operations per
> minute? Dunno anymore what that meant exactly), the best PHP5/MySQL
> solution got 3664 opm. Another interesting one (IMO) was MonetDB with
> 1833 opm. The Java/DB2 Express one got 1537 opm, Java/Oracle 10g
> Express 1412 opm...
>
> [3]: I'm quite sure Alvar's entry would have performed much better
> than mine. AFAICT he has written a quite well optimized
> apache/mod_perl/pgsql solution.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>


Re: database contest in c't (German IT magazine)

От
Michael Dean
Дата:
Markus Schiltknecht wrote:


Markus and the whole gang.  Wow, what an opportunity to miss!  In this
coming year, I will sponsor one contest winner, and I am sure others
would sponsor others.  And what an idea!  Let's have a contest of
submissions for such things that postgresql is better at, and mysql
worst at, which seems to be the result with this one/ michael

Re: database contest in c't (German IT magazine)

От
Josh Berkus
Дата:
Markus,

> OTOH I at least hacked up something. My entry was the only counting one
> using PostgreSQL - which is surprising and disappointing me. (The only
> other PosgreSQL entry from Alvar C.H. Freude unfortunately got
> disqualified because it was sent in too late [3]). Didn't the PostgreSQL
> community know about that contest?

Apparently not.   This is certainly the first I've heard of it.  For one
thing, I don't speak German.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

Re: database contest in c't (German IT magazine)

От
Robert Treat
Дата:
On Monday 12 June 2006 14:46, Markus Schiltknecht wrote:
> Hi,
>
> in the current edition of the german computer magazine c't the results
> of the database contest, which they announced last year, has finally
> been published. It was based on a very simple DVD-Store web application
> from Dell. [1]
>
> Back then I spent some time modifying the original php5 application to
> use PostgreSQL. I've written some stored procedures in C and optimized
> the schema at obvious places. I've been short on time, though, and
> couldn't do everything I wished to do. Most importantly connection
> pooling didn't seem to make it into the final entry I have submitted. :-(
>
> That might be one reason for the disappointing performance result: last
> place, just before the disqualified entries.  The performance trophy
> (once again) has gone to the MySQL Benchmark Team... [2]
>
> With that result I fear I did a disservice to PostgreSQL. Once again it
> seems to be just slower than MySQL. I'm sorry for that. Especially
> because other strengths of PostgreSQL didn't get mentioned.
>
> OTOH I at least hacked up something. My entry was the only counting one
> using PostgreSQL - which is surprising and disappointing me. (The only
> other PosgreSQL entry from Alvar C.H. Freude unfortunately got
> disqualified because it was sent in too late [3]). Didn't the PostgreSQL
> community know about that contest? IMHO it would have been  worthwhile
> to start a community project and submit an entry. Just to get rid of
> that 'too-slow'-image PostgreSQL still has.
>
> At least I have learned: next time I'll try to start a community project
> for such a contest!
>

If you feel strongly about it, you could still start a community project, then
get improvements and spread the word.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: database contest in c't (German IT magazine)

От
Peter Eisentraut
Дата:
Markus Schiltknecht wrote:
> Didn't the PostgreSQL community know about that contest?

It did.  There were extensive discussions on the German mailing list
about it.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: database contest in c't (German IT magazine)

От
"Jim C. Nasby"
Дата:
On Mon, Jun 12, 2006 at 05:04:10PM -0400, Robert Treat wrote:
> On Monday 12 June 2006 14:46, Markus Schiltknecht wrote:
> > Hi,
> >
> > in the current edition of the german computer magazine c't the results
> > of the database contest, which they announced last year, has finally
> > been published. It was based on a very simple DVD-Store web application
> > from Dell. [1]
> >
> > Back then I spent some time modifying the original php5 application to
> > use PostgreSQL. I've written some stored procedures in C and optimized
> > the schema at obvious places. I've been short on time, though, and
> > couldn't do everything I wished to do. Most importantly connection
> > pooling didn't seem to make it into the final entry I have submitted. :-(
> >
> > That might be one reason for the disappointing performance result: last
> > place, just before the disqualified entries.  The performance trophy
> > (once again) has gone to the MySQL Benchmark Team... [2]
> >
> > With that result I fear I did a disservice to PostgreSQL. Once again it
> > seems to be just slower than MySQL. I'm sorry for that. Especially
> > because other strengths of PostgreSQL didn't get mentioned.
> >
> > OTOH I at least hacked up something. My entry was the only counting one
> > using PostgreSQL - which is surprising and disappointing me. (The only
> > other PosgreSQL entry from Alvar C.H. Freude unfortunately got
> > disqualified because it was sent in too late [3]). Didn't the PostgreSQL
> > community know about that contest? IMHO it would have been  worthwhile
> > to start a community project and submit an entry. Just to get rid of
> > that 'too-slow'-image PostgreSQL still has.
> >
> > At least I have learned: next time I'll try to start a community project
> > for such a contest!
> >
>
> If you feel strongly about it, you could still start a community project, then
> get improvements and spread the word.

Yeah, and make sure and mention it here. You'd have almost certainly
gotten volunteers, and possibly support from some of the 'PostgreSQL
companies'.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: database contest in c't (German IT magazine)

От
Christopher Browne
Дата:
After a long battle with technology, xzilla@users.sourceforge.net (Robert Treat), an earthling, wrote:
> On Monday 12 June 2006 14:46, Markus Schiltknecht wrote:
>> Hi,
>>
>> in the current edition of the german computer magazine c't the results
>> of the database contest, which they announced last year, has finally
>> been published. It was based on a very simple DVD-Store web application
> If you feel strongly about it, you could still start a community project, then
> get improvements and spread the word.

There would further be merit to having some of this as a readily
available sample application.  The MySQL guys recently relicensed a
sample database under a BSD-like license so that it could be widely
used for examples in books, presentations, and the likes.

It would be quite handy to have a decently-performant sample
application to use for examples...
--
output = reverse("moc.liamg" "@" "enworbbc")
http://linuxdatabases.info/info/spreadsheets.html
So long and thanks for all the fish.