Victor,

Can you tell us more about your "load" tool? Is is ODBC based?
What platform are you performing these tests on?
Why (how) is the web-server involved in the process?

thanks

"Victor M. Varela" wrote:

>
> 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

--
Edward V. Malloy
Manager, MIS
BBL Leasing, Inc.