At 10:26 AM 29-08-00 -0400, you wrote:

>Victor,
>
>Like Ann, I think it's safe to say that we are all surprise by some of
>the results, accordingly can we have more information.
>
>Please provide as much detail as you can regarding the statements and
>table structures used in the tests.
>
>
>Sean

...and also TRANSACTION(S) - MySQL doesn't use them.
...were the IB and Postgres operations done within one transaction or one
transaction per insert/update?
...any benchmarking where contention is involved? Get locking and
concurrency tangled up in this for some authentic indicators.

(These benchmark results look waaaaay too low for both InterBase and
Postgres -something is wrong if PG is timing out on tests like these!!)

Helen

>-----Original Message-----
>From: Victor M. Varela [mailto:netims1@...]
>Sent: Tuesday, August 29, 2000 5:07 AM
>To: IBDI@egroups.com
>Subject: Re: [IBDI] SPEED-- Product Comparisons
>
>
>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
>
>
>
>
>
>
>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
>
>
>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

http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)