Sorry for long silense, i'm a buzy with other things...
> Thank you for your time Vlad. You wrote:
>
>> Interesting. Could you provide DDL of table and index ?
>
> CREATE TABLE MATBEW
> (
> MSEG_MATNR Varchar(18) NOT NULL,
> MSEG_WERKS Varchar(4) NOT NULL,
> MSEG_LGORT Varchar(4) NOT NULL,
> MSEG_MBLNR Varchar(10) NOT NULL,
> MSEG_MJAHR Varchar(4) NOT NULL,
> MSEG_ZEILE Varchar(4) NOT NULL,
> MSEG_CHARG Varchar(10),
> MSEG_BWART Varchar(3),
> MSEG_SHKZG Varchar(1),
> MSEG_SOBKZ Varchar(1),
> MSEG_XAUTO Varchar(1),
> MSEG_KZZUG Varchar(1),
> MSEG_KZVBR Varchar(1),
> MSEG_MEINS Varchar(3),
> MSEG_MENGE Double precision,
> MSEG_ERFME Varchar(3),
> MSEG_ERFMG Double precision,
> MSEG_BSTME Varchar(3),
> MSEG_BSTMG Double precision,
> MKPF_BUDAT Date,
> MKPF_CPUDT Date,
> MSEG_LIFNR Varchar(10),
> MSEG_EBELN Varchar(10),
> MSEG_EBELP Varchar(5),
> MSEG_WEMPF Varchar(12),
> MSEG_AUFNR Varchar(12),
> MSEG_KUNNR Varchar(10),
> MSEG_KDAUF Varchar(10),
> MSEG_KDPOS Varchar(6),
> MSEG_KDEIN Varchar(4),
> MSEG_WAERS Varchar(5),
> MSEG_DMBTR Double precision,
> MKPF_BLDAT Date,
> CONSTRAINT MATBEW_PK PRIMARY KEY
> (MSEG_MATNR,MSEG_WERKS,MSEG_LGORT,MSEG_MBLNR,MSEG_MJAHR,MSEG_ZEILE)
> );
>
> The additional index (from the other DB):
>
> CREATE INDEX IDX_MATBEW1 ON MATBEW (MSEG_WERKS);
>
>> Also tell us what is charset of database.
>
> It is not defined.
So, all key fileds is VARCHAR with charset NONE, correct ? Is it possible
to have zero
bytes in data values of any of the key fields ? What about leading or trailing
zero's ?
> I know that this is not recommended. I was already
> thinking of defining it to be UTF-8 and than making backup and restore.
>
> Also, I was today thinking of defining 6 indices, each based on only one
> field of the current primary key and see what happens.
>
> Are these tests worth trying?
Sure.
>> Is it reproducible ? I.e. if you restore same backup few times it have
>> missed entries every time ?
>
> I believe this was done, but shall try to do it once more until weekend
> and report here. (My colleague and I have done numerous independent tests
> on various machines last week.)
Any news ?
>> What if you restore same backup at the another machine ?
>
> This was definitely done. No improvement.
>
> Please tell what would be your preferred FB version for these backup and
> restore tests. We have different versions on different machines, so I
> could see what can be done.
2.1.4 or 2.5.0, i.e. latest official release of 2.1 or 2.5
Regards,
Vlad
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
