<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 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">We have a large table in MSSQL, this table we extract data from and drop it into a GeoPackage for further processing. However, the extraction can take some time, its only using 5% of the CPU available, and pulling the data is fairly quick
in debug mode, its really its generation and index creation that is slow. Any tips on speeding this up? We have SSDs and NVME drives, 10gig networking etc.. So. It should be as quick as it can be, but the 5% CPU is what I think the killer is. On this
server 24 cores, so 5% would be right at one core.. Is there no multi-threading or other options here?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;color:#1F497D"><img width="112" height="32" style="width:1.1666in;height:.3333in" id="x_x_x_Picture_x0020_1" src="cid:image001.png@01D8E452.87619480" alt="LTI-Full_175px"></span></b><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;color:#1F497D">Dennis Burgess, Mikrotik Certified Trainer<br>
MTCNA, MTCRE, MTCWE, MTCTCE, MTCINE, MTCSE, HE IPv6 Sage, Cambium ePMP Certified </span>
</b><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;color:#1F497D">Author of "Learn RouterOS- Second Edition”
</span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;color:#1F497D">Link Technologies, Inc</span></b><span style="font-size:10.0pt;color:#1F497D"> -- Mikrotik & WISP Support Services
</span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;color:#1F497D">Office</span></b><span style="font-size:10.0pt;color:#1F497D">: 314-735-0270 Website:
</span><a href="http://www.linktechs.net/"><span style="font-size:10.0pt;color:blue">http://www.linktechs.net</span></a><span style="font-size:10.0pt;color:#1F497D">
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;color:#1F497D">Need to Automate MikroTik Backups:
<a href="https://cloud.linktechs.net"><span style="color:#0563C1">https://cloud.linktechs.net</span></a>
</span><o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;color:#1F497D">Create Wireless Coverage’s with
</span><a href="www.towercoverage.com"><span style="font-size:10.0pt;color:blue">www.towercoverage.com</span></a><span style="font-size:10.0pt;color:#1F497D">
</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>