Subject | Performance with Multiple Databases? |
---|---|
Author | jkees01 |
Post date | 2006-03-27T19:00:41Z |
We were originally having preformance problems with a database that had
30 tables. We took 5 of the most heavily used tables and moved them
into a separate database but made no other modifications except to
point Spring and Hibernate to the new database.
Afert that change we have seen a 5X performance increase. We're a
little confused about why we are seeing this insane performance
increase just from having two tables instead of one.
Does anybody have any theories on this?
30 tables. We took 5 of the most heavily used tables and moved them
into a separate database but made no other modifications except to
point Spring and Hibernate to the new database.
Afert that change we have seen a 5X performance increase. We're a
little confused about why we are seeing this insane performance
increase just from having two tables instead of one.
Does anybody have any theories on this?