Re: [Firebird-test] Stress Testing Firebird

[Radovan B. <ra...@au...>]

Mark O'Donohue wrote:

> So if you would like to support the Firebird project because your a user
> or developer that is likely to benefit from the project, your
> opportunity to contribute has arrived.
>
> So who has some "real world scripts" or ideas on what would look good in
> a stress testing suite :-) ?

Hallo Mark,

I'm not sure if I'm on right place here, but:

I'm trying to port my company's information system (includinig clients,
invoices, stocks, e.t.c)
made in M$ Access foreground on M$ Access background (MDB files, app. 60 MB

of data) to Interbase or Firebird.

I'm trying several months, but I'm always meeting problems that kill me:

- first, it was transliteration errors (already fixed in new ODBC drivers)

now, I usually meet these problems:

- INNER JOINs, taking 10 seconds to run (the same statement with LEFT JOIN
   runs 0.005 sec.)   on IB 6.0.1. and more than 30 minutes on Firebird
0.9.4.
- I have a VIEW made of two tables and VIEW2 made of VIEW1 and another
table.
  On Access, this takes 23 seconds to run. On IB 6.0.1 it takes 20 minutes.

- Some other queries probably put IB in endless loop (I resigned after 30
minutes
   of waiting). And, I was trying statements with 2-4 tables (but, my
program has also
   statements with 10-12 tables)

I can send you these scripts, but probably they will not work on emtpy
tables. so I would send a
piece of my database (dont worry, it would be probably less than 1MB,
packed with
zip, arj, bzip2 or so.) - if you want.

NOTE: I would appreciate some actual beta-build of FB for Windows (newer
that
that from 28.12.2000), so I could make more tests at home. Now I'm working
with
IB 6.0.1 (I stopped using FB 0.9.4, because it was more buggy than IB 6.0.1
for me)

(Please reply me also to ra...@au..., I'm not sure when I come to
read this
mailinglist again)

PS. Also, there are several missing features in IB / FB that are important
for me, that I will
probably discuss later in egoups.ib-priorities.

--

   Radovan Bukoci @ home