Subject AW: [firebird-support] Small Database with very very bad performance on LAN
Author checkmail
Verbose :)

-----Urspr√ľngliche Nachricht-----
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 8. Januar 2016 16:30
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Small Database with very very bad
performance on LAN

Hello,

> Hallo,
> I have a small database (less 100MB) that works on Firebird 2.5.5
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.
>
> I seems to work very well in local but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table
> with less of 5.000 rows!
>
> What i can do?

You have to sort out where your current bottleneck is.

Can you pin-point it to a particular query or is performance in general bad?
With Firebird 2.5, you have quite some monitoring amory, e.g.
monitoring tables (tables starting with MON$...) or the Trace API.

Try to get a big picture with that tooling to see what's going, statement
execution plans etc..., I/O statistics, e.g. is data being fetched from disk
or served from the Firebird cache, which I doubt with your page buffers
value below.

>
> I very novice in Firebird.
>
> The result of gstat is:
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 26613
> Page size 4096
> ODS version 11.2
> Oldest transaction 26603
> Oldest active 26604
> Oldest snapshot 26604
> Next transaction 26605
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 139
> Implementation ID 26
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jan 4, 2016 15:44:10
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*

With SuperServer and a page size of 4096 and a page buffers set of 0, which
gets overriden with a default value of 2048 from firebird.conf (if not
specified otherwise), you end up with a Firebird page cache of 8MB
(!) only for your database.

Increase "Page buffers" to e.g. 10000 (e.g. with gfix command-line tool),
then re-connect your client application and see if this helps.

There is other tuning stuff, but as a first step increasing the Firebird
page cache + getting a big picture on your slow statements, their execution
plan probably pointing to missing indexes ... is a good start.

Good luck.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item on the
main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links