Subject Re: [firebird-support] what schema is better ?
Author Vander Clock Stephane
> <horrible table, indexes, and query omitted>
> >
> > ON MYSQL it's takes very very lot of time (hourS) to return
> > but on Firebird with same amount of data they return immediatly ...
> (firebird soo good?)
> Yes. You've hit one of Firebird's sweet spots, the ability to use
> multiple indexes on a single query. It reads all the indexes,
> setting and clearing bits to indicate whether a particular records
> meets all current criteria, then reads the surviving records in
> storage order.

woow i m now very pround of Firebird :)

> Which MySQL are you using? 4.x, 5.1, 5.5? InnoDB, MyISAM?
> Blackhole is scorchingly fast, but you give up something in
> accuracy. How much do you know about MySQL tuning. When my
> group was benchmarking an InnoDB implementation of DBT2, we
> got about a 5x improvement in performance by tuning ... and not
> the way the documentation says.

for now MySql 5.0 with innoDB. i know unfortunatly nothing about mysql
tuning, i just want to do a bench between mysql and Firebird

you can see the first version of my bench software here :

[Non-text portions of this message have been removed]