Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-25 Thread nonomura
https://github.com/Alexpux/firebird-git-svn/blob/master/src/common/unicode_util.cpp#L1334 Just a heads up: that is an outdated clone of an old repository that was synced from subversion and hasn't been updated since 2015. The Firebird repository is on

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-25 Thread nonomura
Adriano You don't need to be on the development team. You know, you fix, you send pull request. Please put aside those nonsense and pointless arguments. Shall we discuss in a constructive way? Hiro Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 22:08 keltezéssel, Vlad Khorsun írta:   You set DefaultDbCachePages to 65536 and not changed FileSystemCacheThreshold. Thus you completely disabled file system cache. Sorry. I just followed the OLTP's readme_quick_start.txt which not wrote anything about

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 19:05, Gabor Boros wrote: 2018. 10. 25. 17:45 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:37, Gabor Boros wrote: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    It is kinda expected. How many worker isqls you had? Five.    Five ?! It is not serious, try 50 at least I do not want to blow up my test machine.

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:52 keltezéssel, liviuslivius írta: I am also interested Regards, Karol Bieniaszewski I sent it to your address. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:45 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:37, Gabor Boros пишет: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    Could you

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 17:44 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:35, Gabor Boros wrote: 2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread liviuslivius
I am also interestedRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 18:37, Gabor Boros пишет: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    Could you provide html reports generated by the test runs ?

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 18:35, Gabor Boros wrote: 2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    It is kinda expected.

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?   Could you provide html reports generated by the test runs ? Yes. Here or in private? Gabor

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?   It is kinda expected. How many worker isqls you had?

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere? Could you provide html reports generated by the test runs ? Regards, Vlad Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Dimitry Sibiryakov
25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere? It is kinda expected. How many worker isqls you had? -- WBR, SD. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Gabor Boros
2018. 10. 23. 10:23 keltezéssel, Gabor Boros írta: 2018. 10. 22. 17:31 keltezéssel, Dimitry Sibiryakov írta: 22.10.2018 17:28, Gabor Boros wrote: How long distance is enough for the correct results?    Usually it is run for 2-3 hours at least. The attached numbers come from 1 hour. I will

[Firebird-devel] [FB-Tracker] Created: (CORE-5954) Garbage collection in intermediate record versions

2018-10-25 Thread Vlad Khorsun (JIRA)
Garbage collection in intermediate record versions -- Key: CORE-5954 URL: http://tracker.firebirdsql.org/browse/CORE-5954 Project: Firebird Core Issue Type: Improvement Components:

[Firebird-devel] [FB-Tracker] Created: (CORE-5953) Statement level read consistency in read-committed transactions

2018-10-25 Thread Vlad Khorsun (JIRA)
Statement level read consistency in read-committed transactions --- Key: CORE-5953 URL: http://tracker.firebirdsql.org/browse/CORE-5953 Project: Firebird Core Issue Type: New

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-25 Thread Mark Rotteveel
On 24-10-2018 08:20, nonomura wrote: The source code cited below clearly tells the root of the problem that I reported. [..] https://github.com/Alexpux/firebird-git-svn/blob/master/src/common/unicode_util.cpp#L1334 Just a heads up: that is an outdated clone of an old repository that was

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-25 Thread Adriano dos Santos Fernandes
On 25/10/2018 00:01, nonomura wrote: > > (2018/10/24 17:51), Adriano dos Santos Fernandes wrote: >> As I said for you *many* times: if UNICODE (sensitive) has problems, as >> it has, > Nobody seems supporting your assumption. > Ok then. >> how can you changing code under the insensitive flags

[Firebird-devel] [FB-Tracker] Created: (CORE-5952) Enhance restore performance of GBAK using batch API

2018-10-25 Thread Alexander Peshkov (JIRA)
Enhance restore performance of GBAK using batch API --- Key: CORE-5952 URL: http://tracker.firebirdsql.org/browse/CORE-5952 Project: Firebird Core Issue Type: Improvement Components:

[Firebird-devel] [FB-Tracker] Created: (CORE-5951) Add support of batch insert and update operations.

2018-10-25 Thread Alexander Peshkov (JIRA)
Add support of batch insert and update operations. -- Key: CORE-5951 URL: http://tracker.firebirdsql.org/browse/CORE-5951 Project: Firebird Core Issue Type: New Feature Affects Versions: