Subject | Interbase Architecture Question |
---|---|
Author | nprasad3@gmu.edu |
Post date | 2002-02-07T17:01:25Z |
Hi,
I am building a telephony system and want to use interbase as the
backend database. I used postgresql initially and ran into the
following performance problem. Upon reading the interbase documentation
I feel that interbase would lead me to a similar problem.
Problem Description
-------------------
Each trunk on the system has a record in the database. The trunk stores
valuable statistics in this row (frequent updates). PostgreSQL creates
a new record on a UPDATE (something some database guru called MVCC).
Problem is self evident, a busy trunking system would probably do over
100 updates a second. Performance degradation leads to gradual collapse
and vacuuming the database is worse as it locks the tables and freezes
the system.
I found references to versions of rows maintained in interbase similar
to postgreSQL.
http://www.ibphoenix.com/ibp_ods.html
Can someone please tell me whether interbase would be any better for my
application? I have no idea how sybase/ms*/oracle perform under such
conditions.
Thanks in advance
Regards
Nirmal Prasad R.
I am building a telephony system and want to use interbase as the
backend database. I used postgresql initially and ran into the
following performance problem. Upon reading the interbase documentation
I feel that interbase would lead me to a similar problem.
Problem Description
-------------------
Each trunk on the system has a record in the database. The trunk stores
valuable statistics in this row (frequent updates). PostgreSQL creates
a new record on a UPDATE (something some database guru called MVCC).
Problem is self evident, a busy trunking system would probably do over
100 updates a second. Performance degradation leads to gradual collapse
and vacuuming the database is worse as it locks the tables and freezes
the system.
I found references to versions of rows maintained in interbase similar
to postgreSQL.
http://www.ibphoenix.com/ibp_ods.html
Can someone please tell me whether interbase would be any better for my
application? I have no idea how sybase/ms*/oracle perform under such
conditions.
Thanks in advance
Regards
Nirmal Prasad R.