Subject | Re: [firebird-support] Need to optimize this query for my benchmark tools against Firebird / Mysql / Sqlite3 |
---|---|
Author | Vander Clock Stephane |
Post date | 2010-12-20T07:57:35Z |
> Stephane,yes, but not really when we speak about firebird embded for exemple,
>
> > I have done a benchmark tool to compare Mysql / Firebird / SqlIte3
>
> Respectfully, you seem to believe that SQlLite is the "benchmark" by
> which Firebird should be measured.
>
> But from your own postings I understand that SQLLite has a number of
> significant issues in a multi-user/simultaneous operation environment.
>
> It is COMPLETELY inappropriate to compare them.
>
where the use could be similare.
sqllite is not a client server database engine.
> If you want SQLLite performance use it! If you wanti agree ...
> scalable/multi-user/simultaneous operations use Firebird - but don't
> "whine" about performance when significant issues like multi-user
> operations are not supported by SQLLite -- you could get FANTASTIC
> performance from simple key/value databases but that doesn't mean that
> you would want to use it in place of Firebird.
>
> Seanright for myisam ... but innodb handle transaction ?
>
> P.S. As for MySQL, depending on the storage engine used, it is also an
> inappropriate candidate for comparison with Firebird -- the basic ISAM
> storage doesn't support transactions.
>
[Non-text portions of this message have been removed]