Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns
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 https://github.com/FirebirdSQL/firebird Mark Thanks. Then, maybe it is the following: https://github.com/FirebirdSQL/firebird/blob/2d973b902efe5f00d15a1cd533835f8fba3e8e99/src/common/unicode_util.cpp#L1324 Hiro Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns
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 https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 FileSystemCacheThreshold. I will try again the OLTP executions after increase FileSystemCacheThreshold. Thank You! Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 mistake somewhere? Could you provide html reports generated by the test runs ? Yes. Here or in private? Private, please, if no one else interested I sent it to your address. You set DefaultDbCachePages to 65536 and not changed FileSystemCacheThreshold. Thus you completely disabled file system cache. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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. ;-) I can't comment on it, sorry. Nobody tests 5 connections in oltp-emul (for my knowledge, at least). Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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. 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 provide html reports generated by the test runs ? Yes. Here or in private? Private, please, if no one else interested 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. 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 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. ;-) Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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
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 ? Yes. Here or in private? Private, please, if no one else interested Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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. How many worker isqls you had? Five. Five ?! It is not serious, try 50 at least Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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? Five. Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Some OLTP numbers
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 try with 2 and 3 hours. 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? Gabor Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5954) Garbage collection in intermediate record versions
Garbage collection in intermediate record versions -- Key: CORE-5954 URL: http://tracker.firebirdsql.org/browse/CORE-5954 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Vlad Khorsun The ticket is created for documentation purposes. The more detailed description is at doc\README.read_consistency.md -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5953) Statement level read consistency in read-committed transactions
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 Feature Components: Engine Reporter: Vlad Khorsun The ticket is created for documentation purposes. The more detailed description is at doc\README.read_consistency.md -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns
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 synced from subversion and hasn't been updated since 2015. The Firebird repository is on https://github.com/FirebirdSQL/firebird Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns
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 condition >> will fix the problem? > If I were one of the development team, I would insert the following > code to unicode_util.cpp at line 1334 and test the result. > You don't need to be on the development team. You know, you fix, you send pull request. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5952) Enhance restore performance of GBAK using batch API
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: GBAK Affects Versions: 4.0 Initial Reporter: Alexander Peshkov When restoring data gbak sends each record to firebird engine one by one. That's not too bad with embedded connection but when network is involved performance losses are dramatic, specially in WAN case. Batch API is designed to solve such problems and should be used in gbak. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5951) Add support of batch insert and update operations.
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: 4.0 Initial Reporter: Alexander Peshkov Add API that allows to send an array of parameters' sets to server and then make it execute previously prepared statement with each set from this array. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel