Subject Odp: SV: [firebird-support] Important settings f or perfomance

1. Big RAM - bigger then db size
2. SSD drives - not important if defaultdbcache settings allow whole db to be stored in memory - SSD is important if db i bigger then RAM settings and for fast writes and start cache time
3. Fast LAN
4. Ram disk for temp folder for sort and other operations - also for backup and restore process but you must have big RAM

Karol Bieniaszewski

----- Reply message -----
Od: "hhaui@..." <hhaui@...>
Do: <>
Temat: SV: [firebird-support] Important settings for perfomance
Data: wt., kwi 23, 2013 15:48
--- In, Poul Dige <pd@...> wrote:




> > Hi all,

> >

> > our company is developing a system using firebird since years. This system is

> > a "real-time" production steering application.

> > This means for us, that our applications need to perform a lot of different sql

> > (with join over some table) in the shortest possible time. Today if we

> > encounter a slow application behavior, we try to optimize the sql's...

> > I just wonder, what performance would be possible usind firebird, as we are

> > planning to switch to a more flexible database structure, and this will for sure

> > increase the db load.

> > We are using the superClassic with around 30-50 db- users connected. We

> > need to keep our db as small as possible to keep the performance on a high

> > level. This means every year we need to copy away the old data. Actually the

> > fb- process does not often claim to the CPU's limit, so i think the bottleneck

> > are the HDD's, where we are using usuably RAID 1 with fast server HDD's.

> >

> > My question:

> >

> > Is there any complete documentation regarding all the performance critical

> > points for the firebird db?

> > p.e.:

> >

> > What processor to use with which "db- usage- pattern"?

> > -->Up to how many core provide more speed?

> > How to optimally use page size settings (RAM)?

> > What about SSD's? Which modell is good for productive usage?

> > OS- settings, p.e. cluster size of file system?


> Our experience with SSD is that the basic speed in case of just a single connection is improved a bit, but once you have many connections the SSD is hardly affected by the number of connections whereas the mechanical disk is suffering very much with the number of simultanious connections.


> However, page size and buffer size is quite important for SC/CS-configuration as well - you must definitely test the system with different settings (changing the buffer size is quite easy).


> Regards,

> Poul


OK, so this means SSD's could be a very interresting alternative to machanical disk, cause we have a lot of users connected.

What about the other points?

[Non-text portions of this message have been removed]