Subject | Re: [firebird-support] Choosing Firebird Version and Server OS and bits (32 or 64) |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-04-08T12:38:16Z |
Hello,
connections, especially when calculating on-the-fly aggregates on a huge
table, a somewhat huge page buffers value (e.g. 64K) can increase query
performance dramatically.
A huge page buffers value will be useless in a mixed OLTP and OLAP
scenario with Classic. I would find a per-connection page buffer value
with Classic extremely useful for mixed OLTP/OLAP environments. On the
other side, this might be obsolete with Firebird 2.5/3.0 due to better
SMP support in combination with a shared cache.
Just a thought on what I'm currently experience in such an environment. ;-)
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
>> Thanks Anderson, isn't it the case that with 200 users I would be betterFor query intensive tasks in a OLAP scenario with only a few OLAP
>> off
>> running a SS version because of Cache memory?
>
> Probably if most of your users run similar queries... But, You'll benefit
> more from your CPUs... the more users you have the more you'll benefit from
> using more CPUs. I have a site with 200+ cconcurrent users and moving to
> Classic was a *great* performance increase!
>
> BTW, We use FB 1.5, and what I've learned on using classic was: Keep your
> cache settings low (default of 75 pages is fine, it seems that for this
> setting on Clissic *usually* less is more);
connections, especially when calculating on-the-fly aggregates on a huge
table, a somewhat huge page buffers value (e.g. 64K) can increase query
performance dramatically.
A huge page buffers value will be useless in a mixed OLTP and OLAP
scenario with Classic. I would find a per-connection page buffer value
with Classic extremely useful for mixed OLTP/OLAP environments. On the
other side, this might be obsolete with Firebird 2.5/3.0 due to better
SMP support in combination with a shared cache.
Just a thought on what I'm currently experience in such an environment. ;-)
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com