SQL

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: J.L.Francois
Date:  
Subject: SQL
PostgreSQL is not always "slower".

I have used various versions of PostgreSQL and when properly tuned
it performs just as well as MySQL.

Like any tool the operator must be familiar with it to
get the best from it.

My current database is filled with MP3s and I currently get
performance in the range of 1Meg+/sec on selects.

Loading speed is improved by modifying buffer settings and
turning of fsync.


It seems like on Wed, May 10, 2000 at 06:44:16PM -0700, Shawn T. Rutledge scribbled:
Orig Msg> mySQL is known for being fast; PostgreSQL is older, more mature, more
Orig Msg> full-featured, and truly free software under all circumstances. So
Orig Msg> usually I would pick PostgreSQL as "better" unless speed is more important


JLF Sends...

Behold, the Internet is the greatest sum of information at mankind's
fingertips since the Library of Alexandria. Despite this vast storehouse
of knowledge at our disposal, there are still those that will send
urban legend and blatantly false information to mailing lists and
newsgroups without making even the slightest effort to check their
legitimacy. At every occurance this proves to me that every node,wire,
and server I help connect to the Internet to widen its expanse for
the benefit of the masses is a complete waste of time. ( J. Francois )