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. 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?

>     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.)

> 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.

Regards,
Borut



------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to