Re: [firebird-support] Question about few Firebird details

Hi Karol, 44. This option turn off individual savepoints. Our tests proof that gives slight increase in case of massive inserts or updates. Use it with caution, since the rollback will be forced (through TIP), so if you insert less than 50k records, there could be difference with and without

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

23.05.2016 22:08, Bunth Tamás btom...@gmail.com [firebird-support] wrote: > It seems to me that firebird looks for the user name in the security2.fdb > file, which shouldn't be used in an embedded server. What am I missing? There is no embedded server on Linux. You are trying to use Classic

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

On 23 May 2016 at 21:01, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote > >You don't need password, but user name must be. > When I add "SYSDBA" as a user name to the spb of isc_service_attach, I got the following error: *I/O error during "open"

Re: [firebird-support] Question about few Firebird details

23.05.2016 21:05, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > 44. Use NO_AUTO_UNDO - what happend when i do rollback? You will get hard rollback, frozen OAT counter and unavoidable run of sweep. -- WBR, SD.

[firebird-support] Question about few Firebird details

Hi,   https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ i have few questions: 44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not understand what really do this option.. 30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY -  SELECT T.FIELD_KEY,

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

23.05.2016 20:37, Bunth Tamás btom...@gmail.com [firebird-support] wrote: > As far as I know, > I shouldn't pass username/password in the spb to isc_service_attach() in > embedded mode. You don't need password, but user name must be. -- WBR, SD.

[firebird-support] Translating Firebird.MSG - pt_BR

[firebird-support] Backup in embedded mode using C API - authentication problem

Hi, I want to make a backup (.fbk) from a local database (.fdb). As far as I know, I shouldn't pass username/password in the spb to isc_service_attach() in embedded mode. However, I got an error during retrieving information with isc_service_query: *Unable to perform operation. You must be