> Our server originally had a single Firebird database with 30 tables.
> We put 5 of the most havily used tables into their database and
> whitnessed a 5x performance increase in our testing. The tables that
> we split didn't have any links to the remaining tables so the split was
> easy.
>
> This insane boost in performance doesn't really maks any sense to us.
> Does anybody have any theories?

Database cache buffers all available to these tables instead of
to all tables in your original database?

Did you increase the number of page buffers in your original
database?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com