> Many of those collation problems seem to relate to unicode_ci and
> unicode_ci_ai,
> and this relates to the usage of ICU functions.
>
> FB seems to set collation strength properly only where it relates to unique
> index.
> Otherwise the strength is left default, i.e. equivalent of collate
Also, as you use superclassic you have separate cache per connection. It can be
also problem here.
Test on Firebird3 „SuperServer” and you will see if the problem is with
resources caching problem.
Regards,
Karol Bieniaszewski
On 16-10-2018 09:16, hv...@users.sourceforge.net [firebird-support] wrote:
> PS your messages is duplicated in this list, fix it please
That is more likely Yahoo Groups messing up again, this occasionally
causes messages to be sent multiple times (or not at all), and I have a
suspicion that it
Also, as you use superclassic you have separate cache per connection. It can be
also problem here.
Testing on Firebird3 will bring you hint...
Regards,Karol Bieniaszewski
null
Analitico and all,
I found that if I add the a extra field in the index like the pk and
make the index unique it works fine.
Many of those collation problems seem to relate to unicode_ci and
unicode_ci_ai,
and this relates to the usage of ICU functions.
FB seems to set collation strength
>> CI AI indexes are much bigger because of ICU implementation of index
key derivation.
Compareing those icu depending collations, CI AI is smallest.
http://demo.icu-project.org/icu-bin/collation.html
Input
---
ç
C
c
Sort case 1 with sort keys: strength=default (equivalent of collate
16.10.2018 14:02, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support]
wrote:
> . the same query executing alone on the environment, manipulating 5 millions
> of records,
> return is in about 20 minutes;
>
> Anybody have passed for a situation like that or know what are causing it?
Thanks for your attention!
As FB don't have timeout for transaction, what can cause this issue? Do you
have any idea?
Regards,
Marcelo Guimarães
Em ter, 16 de out de 2018 às 09:30, 'Paul Beach' pbe...@mail.ibphoenix..com
[firebird-support] escreveu:
>
>
>
> > I would like to know if the
> I would like to know if the Firebird have any kind of timeout on query
> execution.
Firebird 4.0
http://tracker.firebirdsql.org/browse/CORE-985
Paul
I would like to know if the Firebird have any kind of timeout on query
execution.
I´m asking that because we are facing the following situations:
.. query executing alone on the environment, manipulating 4 millions of
records, the return is in seconds;
.. the same query, executing in parallel
I'm out of the office till the 18th of October with a limited access to my
emails.
With the best wishes,
Georgiy Kovalov
---In firebird-support@yahoogroups.com, wrote :
> I found that if I add the a extra field in the index like the pk and make
> the index unique it works fine.
Ok.
> Is expected to work fine even with the bug that you refer ?
Not sure what is "fine" here. In any case -
12 matches
Mail list logo
