Re: Inserts optimization?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux