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