> 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?
>

INDEXES - you must have a difference in your indexes - check them carefully
Alan