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 https://lists.sourceforge.net/list

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 ta

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 Firebird-De

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 4

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 interface

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. In

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 https://l

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 https://lists.sourceforge.net/

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 -B(ACKUP_

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 inte

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? Ad

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 liviuslivius

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 https://lists.sourceforge.net/

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 https://www.tabso

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