Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-16 Thread nonomura nono181...@yahoo.co.jp [firebird-support]
>> 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 uni

Fwd: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-15 Thread Analitico analitic...@gmail.com [firebird-support]
You are telling me that in my example the index unicode_ci_ai of two varchar(10) don't fit in a 8K page but with Unicode fit ? What page size do you recommend ? A segunda, 15/10/2018, 20:14, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 15.10.2018 15:00, Luis Forra luis.fo

Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-15 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
You are telling me that in my example the index unicode_ci_ai of two varchar(10) don't fit in a 8K page but with Unicode fit ? What page size do you recommend ? A segunda, 15/10/2018, 20:14, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 15.10.2018 15:00, Luis Forra luis.fo

Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.10.2018 15:00, Luis Forra luis.fo...@gmail.com [firebird-support] wrote: > What I'm doing wrong ? CI AI indexes are much bigger because of ICU implementation of index key derivation. You must increase page size of your database to return index depth to norm. -- WBR, SD. ---