--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

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

Thank you, that make more sense to me now. The new database had the
same size cache buffer. So I guess we doubled our cache.

I apologize...I just logged the same question again because I got
wierd message from our mail server and hadn't seen our question
posted. Please ignore it.

Thanks,
--Jeff