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



  • [firebird-supp... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
    • Re: [fire... Daniel Rail dan...@accra.ca [firebird-support]
      • Re: [... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
    • Re: [fire... Tim Ward t...@telensa.com [firebird-support]
      • Re: [... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
    • Re: [fire... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
      • AW: [... 'checkmail' check_m...@satron.de [firebird-support]
      • Re: [... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]

Reply via email to