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

> 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

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

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] Re: An SQL query perform badly after firebird database file size grow beyond 8GB

cyc...@gmail.com [firebird-support] a écrit : > > Is this an issue related to Windows file system? Firebird service or my > query? for test : SELECT MAX(A.PostDate) MaxPostDate from ( select a.postdate FROM SL_CS A, SL_CSDTL B WHERE A.DocKey=B.DocKey AND A.Code='300-10001' AND

Re: [firebird-support] An SQL query perform badly after firebird database file size grow beyond 8GB

Hi, There should a reason why optimizer chooses the wrong plan. Try to recalculate indices statistics. Also, for general performance, use optimized Firebird configuration: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com I am

[firebird-support] An SQL query perform badly after firebird database file size grow beyond 8GB

I am using Firebird 2.5.5 x64 on Windows 8.1 x64. I wrote an application access a Firebird database. So far so good. One day, I notice a function running query accessing the database become extremely slow. After I debug, I found the query is the cause: SELECT MAX(A.PostDate)

Re: [firebird-support] Need Support to connect to the database

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

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

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

[firebird-support] Architecture

Hello, I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation of Firebird too? I connect with odbc. Known Issues while migration, metadata etc. ? Thanks in advance. Best regards. Olaf

Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since we > have a quadcore CPU, we are using cs. > > UDFs can I replace with build in functions I guess you can imagine that you first need to do that before backing up and restoring? > Now, I have restored the database with 2.5,

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

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

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] Architecture

Hello Olaf, > Hello, > > I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to > Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation > of Firebird too? From an operational POV, a main factor with moving from 32-bit to 64-bit is if you are using (third-party)

AW: [firebird-support] Architecture

Hello Thomas, Thanks. For some Years, we have had in use the superserver, but since we have a quadcore CPU, we are using cs. UDFs can I replace with build in functions Now, I have restored the database with 2.5, but.. Errors :( Now I have seen the new switches -fix_fss_d and m, but now I get

AW: AW: AW: AW: [firebird-support] Architecture

-verbose :) I remember me. So I can see what table is he problematic one. Have a nice weekend, Thomas, many Thanks :) -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 8. Januar 2016 17:28 An:

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

AW: AW: AW: [firebird-support] Architecture

Yes, Thomas, it woks with 2.1. In the release notes of 2.5.X is written: Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw the error "value exceeds the range for valid timestamp". But where can I search 200 Tables... -Ursprüngliche Nachricht- Von:

Re: AW: AW: AW: [firebird-support] Architecture

> Yes, Thomas, > > it woks with 2.1. In the release notes of 2.5.X is written: > > Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw > the error "value exceeds the range for valid timestamp". > > But where can I search 200 Tables... Read Paul's blog on using -v for the

AW: AW: [firebird-support] Architecture

Hello, now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1 It works fine, but there is another problem to fix. Now I get the error, that value exceeds the range for valid timestamps. How can I fix this issue? I have installed fb as cs without superclassic under 32 Bit

Re: AW: AW: [firebird-support] Architecture

> now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1 > > It works fine, but there is another problem to fix. Now I get the error, > that value exceeds the range for valid timestamps. How can I fix this issue? * When does that happen during the restore? * Does a backup

AW: AW: [firebird-support] Architecture

200 Tables :( Looking for timestamps before '16.11.1858 00:00:01' Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 8. Januar 2016 17:01 An: firebird-support@yahoogroups.com Betreff: AW: AW: [firebird-support] Architecture Hello, now,

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

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

ODP: Re: [firebird-support] Need Support to connect to the database

hi, by what software/driver do you try to connect. did you try connecting by isql?If you can not connect by isql then i suppose password was changed regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Jianbo Li l...@stunningtech.com [firebird-support]"