Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: Perl/PostgreSQL niche

by merlyn (Sage)
on Sep 06, 2005 at 13:02 UTC ( [id://489479]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Perl/PostgreSQL niche
in thread Perl/PostgreSQL niche

PostgreSQL targets a full set of features, when MySQL aims performance.
But from what I have read, it aims and misses, at least when you have an application that requires lots of updates, like a big e-commerce site.

Without PostgreSQL's MVCC "concurrent update" feature, MySQL programs are required to lock the entire table to perform updates. This gets to be the bottleneck for such applications.

So, while MySQL may be "speedier" on simple tests or mostly-readonly accesses, PostgreSQL is faster (and some say more robust) for real transactions.

MySQL is structured access to files. PostgreSQL is a real transactional database. Your needs determine which is more appropriate. But please stop trotting out "speed" as a complete determiner.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.

Replies are listed 'Best First'.
Re^4: Perl/PostgreSQL niche
by dbwiz (Curate) on Sep 06, 2005 at 15:28 UTC
    But from what I have read, it aims and misses

    You haven't read the entire story, I'm afraid.

    MySQL programs are required to lock the entire table to perform updates.

    That is not correct. Since version 3.23, MySQL has had the capability of locking at record level, using InnoDB tables.

    I am administering an application where a MySQL database handles several thousand of concurrent updates, using transactions and referential integrity, without effort, providing a high level of efficiency.

    A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://489479]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2024-03-28 09:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found