[firebird-support] FB 2.5 migrate to 3.0

2017-01-06 Thread James mallee....@gmail.com [firebird-support]
Dear Sir/Madam, I am trying to migrate my database from 2.5 to 3.0 now. It was tested before and worked successfully with great help from firebird community. But unfortunately, all my notes were gone with my lost laptop. Now I show all my steps I have done for migration procedure. 1. Use gbak

Re: [firebird-support] Case sql

2017-01-06 Thread setysvar setys...@gmail.com [firebird-support]
Den 05.01.2017 17:49, skrev 'Stef' s...@autotech.co.za [firebird-support]: > Hi Karol > > Thank you for the feedback, I understand what you mean, but how would I go > about adding or changing to get the “group by”? Hi Stef! I'm not Karol, but being that you want them on one line, I think you

[firebird-support] Stored procedure return multiple resultsets?

2017-01-06 Thread 3xhs4j5sncjhudgg3baustwt7mrmz5hy3x6i4...@yahoo.com [firebird-support]
Will Firebird 4.0 support stored procedures returning multiple resultsets to the application layer? All other DBMS support such a feature. The whole point of stored procedures are to encapsulate SQL logic and sometimes it is required to send multiple record sets to the application layer.

Re: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, Jan 5, 2017 at 9:54 PM, trsk...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > As you know, on a single connection, Firebird's cpu utilization calculate > by 100% / no of cores. > That's not an arbitrary limit. Firebird is not capable of running a single

Re: [firebird-support] slow connection time to the db

2017-01-06 Thread Tim Ward t...@telensa.com [firebird-support]
Could be worse, at least you haven't run into the infamous Java spurious reverse DNS lookup timeout ... which is 30 seconds. On 06/01/2017 13:31, Marianne Castel - Titelive caste...@titelive.be [firebird-support] wrote: Thanks Dimitry, I'll ask my server's administrators to have a look in

RE: [firebird-support] slow connection time to the db

2017-01-06 Thread Marianne Castel - Titelive caste...@titelive.be [firebird-support]
Thanks Dimitry, I'll ask my server's administrators to have a look in that direction. Marianne Castel Development team -Message d'origine- De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 5 janvier 2017 15:03 À :

Re: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.01.2017 3:54, trsk...@yahoo.com [firebird-support] wrote: > please help me to point out which codes I should change & if my knowledge is > enough is I > only have basic C? No way you or someone else can do this with current Firebird architecture, sorry. -- WBR, SD.