|Subject||Re: [firebird-support] what schema is better ?|
|Author||Vander Clock Stephane|
>woow i m now very pround of Firebird :)
> <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.
> Which MySQL are you using? 4.x, 5.1, 5.5? InnoDB, MyISAM?for now MySql 5.0 with innoDB. i know unfortunatly nothing about mysql
> 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.
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]