From: Markus Schaber <schabi@logix-tt.com>
To: Magnus Hagander <mha@sollentuna.net>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Inserts optimization?
Date: Wed, 19 Apr 2006 14:50:26 +0200
Message-ID: <44463212.2010708@logix-tt.com> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA352C3@algol.sollentuna.se>
References: <6BCB9D8A16AC4241919521715F4D8BCEA352C3@algol.sollentuna.se>
Hi, Magnus,
Magnus Hagander wrote:
>>To support mysql, they break performance for _every other_
>>database system?
> Actually, it probably helps on SQLite as well.
AFAICS from the FAQ http://www.sqlite.org/faq.html#q7 and #q8, SQLite
does serialize itsself.
> And considering they only
> support postgresql, mysql and sqlite, there is some merit to it from
> their perspective.
Okay, I understand, but I hesitate to endorse it.
IMHO, they should write their application in a "normal" way, and then
have the serialization etc. encapsulated in the database driver
interface (possibly a wrapper class or so).
>><cynism>
>>Now, I understand how the mysql people manage to spread the
>>legend of mysql being fast. They convince software developers
>>to thwart all others.
>></>
> Yes, same as the fact that most (at least FOSS) web project-du-jour are
> "dumbed down" to the mysql featureset. (And not just mysql, but
> mysql-lowest-common-factors, which means myisam etc)
Well, most of those projects don't need a database, they need a bunch of
tables and a lock.
Heck, they even use client-side SELECT-loops in PHP instead of a JOIN
because "I always confuse left and right".
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabi@logix-tt.com, mha@sollentuna.net
Subject: Re: Inserts optimization?
In-Reply-To: <44463212.2010708@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox