Subject | Firebird performance Sheets |
---|---|
Author | emb_blaster |
Post date | 2008-08-06T19:43:26Z |
I´ve thinking...
There´s many questions about Firebird performance, optimizing, etc...
But I don´t found one guide to know if a BD is realy slow or not, if
it (firebird) is running in his fullcharge or is missused.
There´s one "Firebird performance Sheets", or anyone could post what
they reached in daily use?
For example in Firebird Experts Forum someone tell that:
"... +- 50 Million rows in one table (only one table in database) and
the size of the file is about 30 GB. There are 8 indexes on it with
one unique index consisting of 2 fields. Finding a row given the
unique index values is relatively quick , from a few milliseconds to 2
seconds the most. My problem is inserts, they are extremely slow. Some
will go fast and then it will get stuck for easily for about a minute
on one and carry on again."
Well, on my DB I had more than 230.000, but it is increasing and
will become that huge (+-30 million)... will it become so slow too?
A Firebird performance Sheets should help.
Regards
There´s many questions about Firebird performance, optimizing, etc...
But I don´t found one guide to know if a BD is realy slow or not, if
it (firebird) is running in his fullcharge or is missused.
There´s one "Firebird performance Sheets", or anyone could post what
they reached in daily use?
For example in Firebird Experts Forum someone tell that:
"... +- 50 Million rows in one table (only one table in database) and
the size of the file is about 30 GB. There are 8 indexes on it with
one unique index consisting of 2 fields. Finding a row given the
unique index values is relatively quick , from a few milliseconds to 2
seconds the most. My problem is inserts, they are extremely slow. Some
will go fast and then it will get stuck for easily for about a minute
on one and carry on again."
Well, on my DB I had more than 230.000, but it is increasing and
will become that huge (+-30 million)... will it become so slow too?
A Firebird performance Sheets should help.
Regards