[firebird-support] Dynamic Memory Allocation

Hi Todd, your description sounds like a problem with the concurrent connections. SuperServer works mostly sequential. So maybe there is a long taking query blocking the others. Maybe you should give a try to SuperClassic. For more information see http://www.firebirdsql.org/manual/qsg25-appx-ar

[firebird-support] Upgrade from 2.5.2 to 2.5.4

Is a Backup and Restore Required?

[firebird-support] Dynamic Memory Allocation

I have a client that is running Windows Server 2008 R2. All that runs on this server is our application that is using Firebird Version 2.5.2. Superserver. When I look at the Task Manager it shows that there is a total of 2GB of RAM. That the system is typically using 80% of this. I thought the

Re: [firebird-support] Conditional where statements

My mail was not complete yet :-) Another solution could be building the query up with the conditions and use "EXECUTE STATEMENT " in the stored procedure But note that this has also drawbacks, the query need to be prepared every time the SP is called, but this could still win due the beter

Re: [firebird-support] Conditional where statements

Hi, Another solution could be building the query up with the conditions and use "EXECUTE STATEMENT " in the stored procedure Kind Regards, Arno Brinkman ABVisie -Oorspronkelijk bericht- From: Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] Sent: Thursday, Novembe

Re: [firebird-support] Conditional where statements

Hi Alan, It might not be an elegant solution, but I think you could also union the same query together 8 times and have the where clause "short circuit" if it is not supposed to execute. I would love to hear if anyone has any better ideas though, as this slowdown is something we have also seen.

[firebird-support] Conditional where statements

Hi, I have a SP that has been running as is for many years on various servers and the performance is very acceptable. However, I have just replaced a dual Xeon test server with - wait for it! - a Raspberry PI 2 running a customised Linux OS. It runs perfectly well and I've benchmarked a number

Re: [firebird-support] FB 2.5.4 - new handling of IN SUBSELECT?

Den 05.11.2015 12:12, skrev Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]: > Hi! > > I wonder: Was there any change in FB 2.5.4 which would slow down > processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I > have been performing tests because a user of mine complained a

[firebird-support] Re: FB 2.5.4 - new handling of IN SUBSELECT?

05.11.2015 14:12, Josef Kokeš j.ko...@apatykaservis.cz wrote: > > I wonder: Was there any change in FB 2.5.4 which would slow down > processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I > have been performing tests because a user of mine complained about slow > speed of my databa

[firebird-support] FB 2.5.4 - new handling of IN SUBSELECT?

Hi! I wonder: Was there any change in FB 2.5.4 which would slow down processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I have been performing tests because a user of mine complained about slow speed of my database, and found out that my query in the form of: SELECT COUNT(*)