RE: [Firebird-test] Benchmark Comparisons

[Skopalik S. <sko...@hl...>]

My tips:
1. pure SQL engine speed in SP and trigers as computing,
 logical expresion, raising errors, UDF calling.

2. Single table performance in inserting rows, deleting updating
  all operation with single PK (common operation), group by, agregate functions

3. Single and composite indexies speed.
  Selecting by part of composite index, min, max operation

4. Disk IO speed like natural scan, writing large blob, fetching
  large blob, multi client operation with large data (cache performance)

5. Complex query like selection up to max table in query (may be 16?)
  where optimizer query plan failed

Very useful will be comparition between all version of FireBird.

	Slavek


> I'm documenting a comparison of speed and data throughput for Firebird,
> PostgreSQL, and MySQL, and I'm wondering if this is the place to ask people
> about tuning parameters to squeeze the most out of Firebird.
> 
> OS: FreeBSD
> CPU: 2x 415MHz Celerons
> RAM:380MB
> HDD: ata66 20GB (hope to use 10GB for each test)
> 
> Sure, it's small, but each database has to run in the same environment
> 
> Any tips so far? Example Schema's?
> 
> Looking forward to replies
> 
> Nige.
>