<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE-CH link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi Ruslan, Ivan<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>CLONE was <span lang=EN-US>extremely</span><span lang=EN-US> </span><span lang=EN-US>slow</span>. <span lang=EN-US>I have a 4 month old DB with some segment errors (again)! I start the CLONE on a ProLiant server RAID5, i7 processor 4 month old, or in short a very potent server. The whole process runs over 20 hours!!!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Some words to our DB:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>This DB contains about 7’000 patients and 50’000 appointments, 20’000 invoices and 20’000 treatments. This 90’000 records points all to one of the patients. The sizes are 1.5 GB BLB and 350 MB DAT.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Some words to the process:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>About 90% of the BLB file was done in one hour. After that the population of the DAT file seems to go on. But after about 2 hours this process seems to nearly sleep (about 500 Bytes every few minutes). The overall time depends not heavily of the size of the BLB (I tried this with a DB with a BLB size of 4GB but only 5’000 patients that runs in 8 hours).<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I don’t know what CLONE exactly does. But I think that it make some sequential searches or adjustments. As soon as you reach the patients you iterate for each of them through every of the about 100’000 pointers…<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>If this statement is in any way correct – why not simply read the pointers into memory, make QSort and use a binary search?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Really, Ruslan, we have the need for speed!!! It was no problem if CLONE runs 1 or 2 hours but 20h is ways too much. The good side, the result is correct.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>AND: As I wrote you in an earlier mail: If I take the cloned DB and make a new clone of this, the process runs in about 10 times faster!!! I argued that this is because you flag unchanged segments or pages but you answered to me that this is because of the caching of Windows. But that cannot be the case because I see the same behavior if I copy the ne DB to another PC. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:DE-CH'>Please, please discuss this with yourself and Ivan!<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:DE-CH'>Regards<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:DE-CH'>Fabian<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:DE-CH'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>