Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> Hallo, > > Il 08/01/2016 16.22, Tim Ward t...@telensa.com [firebird-support] ha scritto: >> What are your queries, query plans, query statistics? > > The queries are similar to: SELECT * FROM TABLE. > > Investigating for query plans, statistics, Buffers as suggested by > Thomas, I discovered the

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo, Il 08/01/2016 16.30, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] ha scritto: > 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,

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo, Il 08/01/2016 16.22, Tim Ward t...@telensa.com [firebird-support] ha scritto: > What are your queries, query plans, query statistics? The queries are similar to: SELECT * FROM TABLE. Investigating for query plans, statistics, Buffers as suggested by Thomas, I discovered the origin of

[firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
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

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Daniel Rail dan...@accra.ca [firebird-support]
Hi, At January 8, 2016, 7:50 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > 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

AW: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread 'checkmail' check_m...@satron.de [firebird-support]
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

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Tim Ward t...@telensa.com [firebird-support]
On 08/01/2016 11:50, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > 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

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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

Re: [firebird-support] Small Database with very very bad performance on LAN

2016-01-08 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo, Il 08/01/2016 14.20, Daniel Rail dan...@accra.ca [firebird-support] ha scritto: Have you tried with SuperClassic or Classic? SuperServer 2.5.5 still Ok, I tried SC and CS and the performance on LAN seems best of SS but not good :( May be the performance of CS is best of SC but