Ann, I know that every database engine implementation is somewhat a compromise between reasonably good speed on the average, good concurency support, robustness, etc, etc and that every engine has its own inherent weaknesses.

My interest in FB is precisely motivated by the fact that this database offers very good performances on the average, very good SQL standard coverage, triggers, stored procedures, with excellent robustness for a very low administration cost ! When you add that it can be used very easily as an embeded database for free, what else would one like ? ... Hmm, well, support for more platforms maybe ! ;-) BTW, if there are people interested by an AIX build of FB, I've got one that should be available soon...

Of course, I know that my test is not representative of real life access to a production database; this is not what I had in mind.
No, I was just surprised that this basic scenario took so much time. 3 or 4 minutes of elasped time, well ok; but nearly one hour; yes it surprises me.

regards,

Toon



"Ann W. Harrison" <aharrison@...> wrote:
grostoon wrote:

> I'm going to do the same test with postgresql, mysql (with innodb tables) and oracle to see what timings I get.
>

Fine, but do understand that you've chosen the worst possible
set of operations for Firebird. Like most things in life, database
system design is a series of trade-offs. The same multi-version
concurrency control that makes count (*) slow and imposes a clean-up
cost on transactions that follow a large delete also gives us
non-blocking reads, instant recovery after a system crash, and
avoids the need for separate logs, journals, vacuum operations, etc.
If you don't care about multi-user performance, your tests are fine,
but if you do care, test a reasonable mix of concurrent update,
insert, and reporting transactions before you pick a database.

Regards,


Ann



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS
Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Microsoft technical support

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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