Re: [Firebird-devel] Generating transactions

2019-08-12 Thread Jiří Činčura
On Fri, Aug 9, 2019, at 17:59, Dmitry Yemanov wrote: > call) but getting long transaction numbers from e.g. isc_database_info() > may show surprises. Correct. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Dmitry Yemanov
09.08.2019 18:39, Mark Rotteveel wrote: to testing client libraries and client side applications. What would be tested in client library? You started this thread because you wanted to test a client library, so you should already know reason for testing a client library. I think he was

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Mark Rotteveel
On 2019-08-09 13:29, Jiří Činčura wrote: to testing client libraries and client side applications. What would be tested in client library? You started this thread because you wanted to test a client library, so you should already know reason for testing a client library. Mark

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
I have tested it before and now also. gbak -c -v -START 123456789 and database after restore looks like Database header page information: Flags 0 Checksum12345 Write timestamp Aug 9, 2019 15:17:08 Page size

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Slavomir Skopalik
In case, that you use transaction ID for business logic and needs to only going up. Slavek Ing. Slavomir Skopalik Executive Head Elekt Labs s.r.o. MASA - Collection and evaluation of data from machines and laboratories http://eng.elektlabs.cz/products-and-services/masa

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Dimitry Sibiryakov
09.08.2019 13:19, liviuslivius wrote: But it is as an options listed in "gbak -?" I'm afraid that meaning of this switch could be a little different from what you propose and it sets starting transaction for recovery from journal. -- WBR, SD. Firebird-Devel mailing list, web

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
>>You mean for transaction handle? This really depend what client library do. I do not go into details about client libraries which i do not write, but i am talking abut transaction numbers. This was only sample where it can be usefull. For me it will be usefull in application developement.

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Jiří Činčura
> If it is working ok in such situation like "id" greater then integer > and some code in the library can have e.g. variable declared as > integer. You mean for transaction handle? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
>>What would be tested in client library?If it is working ok in such situation >>like "id" greater then integer and some code in the library can have e.g. >>variable declared as integer.  Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
I do not remember where i found this info before, i can't find it now to show details about. But it is as an options listed in "gbak -?" -A(RCHIVE_DATABASE) backup database to archive -ARCHIVE_J(OURNALS) backup journals to archive -ARCHIVE_R(ECOVER)recover database from archive

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Jiří Činčura
> to testing client libraries and client side applications. What would be tested in client library? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
>>Other than engine debug of greater IDs, what would this be used for? to testing client libraries and client side applications. regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Dimitry Sibiryakov
09.08.2019 12:37, liviuslivius wrote: i have checked this now and i see this was in Interbase:  -START(ING_TRANS)     starting transaction ID for restore I don't see such option in Interbase XE7 documentation. Could you provide a link? -- WBR, SD. Firebird-Devel mailing list, web

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread Adriano dos Santos Fernandes
On 09/08/2019 07:37, liviuslivius wrote: > Hi >   > i have checked this now and i see this was in Interbase: >  -START(ING_TRANS)     starting transaction ID for restore >   > Maybe it is time to add this also to Firebird? > Other than engine debug of greater IDs, what would this be used for?

Re: [Firebird-devel] Generating transactions

2019-08-09 Thread liviuslivius
Hi   i have checked this now and i see this was in Interbase:  -START(ING_TRANS)     starting transaction ID for restore   Maybe it is time to add this also to Firebird? Should i create such ticket in the tracker?   regards, Karol Bieniaszewski     W dniu 2019-08-04 17:00:11 użytkownik

Re: [Firebird-devel] Generating transactions

2019-08-04 Thread liviuslivius
Hii remember that was a switch in gbak restore, to restore db with next transaction set for specified value. But maybe this was Interbase not Firebird i have not access to the computer nowRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at

Re: [Firebird-devel] Generating transactions

2019-08-01 Thread Jiří Činčura
>Set FW=OFF, MaxUnflushedWrites = -1, MaxUnflushedWriteTime = -1 Interestingly settings the MaxUnflushedXxx does not have a significant effect. In case somebody is doing the same... Using 2 connections/threads seems to be the sweetspot on my machine. -- Mgr. Jiří Činčura

Re: [Firebird-devel] Generating transactions

2019-08-01 Thread Vlad Khorsun
01.08.2019 11:52, Jiří Činčura wrote: Hi *, this might seem silly, but is there a very fast way to generate transactions in Firebird? I'm trying to test new bigger transaction IDs in .NET provider. As far as I know using multiple connections in parallel is not going to help. So far I'm doing

Re: [Firebird-devel] Generating transactions

2019-08-01 Thread Jiří Činčura
Oh yeah. Forced writes help a bit. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Generating transactions

2019-08-01 Thread Jiří Činčura
Hi *, this might seem silly, but is there a very fast way to generate transactions in Firebird? I'm trying to test new bigger transaction IDs in .NET provider. As far as I know using multiple connections in parallel is not going to help. So far I'm doing simple execute block: execute block as