This message can serve as comparison in speed quality.

Two days ago, I have used a tool called http_load to benchmark two web servers
(Apache and Thttpd) and this last with PHP4 and Interbase 6, MySQL 3.22 and
PostgreSQL 7 (all out of the box and all free software, including Linux).

These were the results.

This is the machine cpu info:

processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 3
model name : Pentium II (Klamath)
stepping : 3
cpu MHz : 266.621612
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
sep_bug : no
f00f_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 sep mtrr pge mca cmov
mmx
bogomips : 266.24

and only 64 Mb of RAM.


WEB SERVERS

1) Get 100 times a 50K file using 25 parallel conections:

http_load -parallel 25 -fetches 100 fichero_50k

Thttpd: 2.61857 sec
Apache: 3.69183 sec

2) Get max. times same file using 50 parallel conections in a minute

Thttpd: 22538 times
Apache: 14897 times



DBMS

a) insert 10000 records (structure id(number), name(100 chars))
b) show them (select and fetch)
c) update them (id = in + 50000)
d) delete table


Interbase 6 + Apache:
Insert: 34.7109 sec
Show: 10.348 sec
Update: 3.65113 sec
Delete: 1.87868 sec

Interbase 6 + Thttpd:
Insert: 30.9008 sec
Show: 7.44108 sec
Update: 3.9474 sec
Delete: 1.49845 sec

MySQL 3.22 + Thttpd:
Insert: 8.28551 sec
Show: 5.4 sec
Update: 1.15765 sec
Delete: 0.043181 sec

PostgreSQL 7.02 + Thttpd (ONLY 1000 RECORDS, 10000 GOES TIME OUT)
Insert: 30.9548 sec
Show: 0.332144 sec
Update: 0.757638 sec
Delete: 0.071223 sec


My conclusions (maybe stupid):

I was been talked that PostgreSQL 7 (that includes foreign keys) have been
improved in speed. Somebody has told me that out of the box Postgres has a
ratio of 33 inserts per second but it can be set to rise 450 per second. 33
inserts per second in default configuration seems to be a joke.

In my opinion, if you need transactions and foreign keys, the best solution if
Interbase, otherwise your DBMS must be mySQL by its perfomance.

--
Programmer
Integracion de Metodologias y Sistemas (Spain)
http://www.netims.com

"Leyne, Sean" <sleyne@...> dijo:

> All,
>
> I will be making a presentation on Interbase 6.0 and Open-Source SQL
> DBMS at next week's Toronto Delphi Users Group meeting.
>
> As such I'm in the process of developing some comparison notes,
> regarding the direct competitors to IB (most noteably mySQL and
> PostgreSQL) and would appreciate some input from the community.
>
> To that end, I would like to use the accumulated knowledge to:
>
> - Identify other open-source SQL DBMS which you consider to be
> real competitors to IB (not a simple list from the open-source.org web
> site)
> - Outline the key differences which distinguish between these
> products and IB
>
> Accordingly, if you know of other open-source products, please provide
> their web site URL.
>
> Additionally, while I am navigating through the loads of information on
> the respective web sites, I would appreciate of direct feedback from
> those of you who have had direct experience with the other products (or
> have done some recent product comparisons). I'm looking for is both the
> good and the bad, as the products compare with IB.
>
> In this manner, I hope to present as accurate a picture as possible --
> my intention is to be as fair as possible.
>
>
> Sean
>
> PS. Paul and Ann, I just went up to the mySQL web site and used
> their product comparison pages. To my mind, their are a number of
> factual errors related to IB capabilities, in some cases they seem
> glaring. Thought you should know. (I'd try to push from some
> corrections [they say they will correct error if prompted], myself, but
> don't feel knowledeable enough to put forward an informed case)
>
>
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
>
>

--
Programmer
Integracion de Metodologias y Sistemas (Spain)
http://www.netims.com