<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)">
<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
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.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.style1, li.style1, div.style1
{mso-style-name:style1;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Bulkfetch relates to “how many” records to retrieve from the database on each read. (you may process the records one at a time,<o:p></o:p></p>
<p class="MsoNormal">But it helps with network latency if you transfer records in bulk instead of one at a time…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Without seeing any records or code, It’s hard to tell exactly “why” it’s failing for you.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">“My working Guess” would be that you are working with a very fat record or record complex, and are hitting memory constraints<o:p></o:p></p>
<p class="MsoNormal">Trying to get 1000 records in a single read. Without an explicit bulkfetch, “I think” you are defaulting to something around 20 records at a time.<o:p></o:p></p>
<p class="MsoNormal">If that gives you performance issues, put the bulkfetch back in, but lower the record count quite bit, to say 100. (1000 seems a bit high).
<o:p></o:p></p>
<p class="MsoNormal">Basically you are trading memory resources for speed with bulkfetch, but you do have to have the resources to trade away for that speed…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If your application is highly concurrent, you may be having issues with record locking grabbing 1000 records at a time, (but this is a very<o:p></o:p></p>
<p class="MsoNormal">Remote possibility, my money would be on using more memory buffering than you can support for a large transaction…).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> powerh-l <powerh-l-bounces@lists.sowder.com> <b>
On Behalf Of </b>Mark Toms<br>
<b>Sent:</b> Tuesday, August 11, 2020 12:21 PM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> [External] qtp bulkfetch swtich<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">HI All</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">I am busy looking at the qtp application and why it does not allow me to update table in database ,
</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">I see that current implementation has a default parameter of bulkfetch=1000 .</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">Would anyone happen to know what the bulkfetch parm is for ?</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">It is related to relational database tuning , but I don’t have specific detail.</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> The powerhouse manual I have , does not include it as reference.</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">When I remove the parm , my update works .
</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">::::::::::::::</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">qtp</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">::::::::::::::</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"># only two parameters required
</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">$PH_USR/bin/qtp cc="(UNIX,$hpaccount)"
<span style="color:red">bulkfetch=1000</span></span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">::::::::::::::</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">qtpaudit</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt">::::::::::::::</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-GB" style="font-size:12.0pt"># only two parameters required
</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt">$PH_USR/bin/qtp cc="(UNIX,$hpaccount)"
</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Bulkfetch reference mentioned in context of tweaking Sybase for powerhouse .<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><a href="https://l.antigena.com/l/gXm9bcAV3rWrWKY5M-0uluoZD7Gg8ZnWBGG8ZhEoykiSgBoEho_LMq--Tgpz1KFyxam02yzEHGn2h2hR_0pnqZgkirw7oyPorGjCfh8KsP6JF8EmP9wDL2I35GVeeVTAV0Ais9-oCK3bVxszlA7ljASTiN1h1rX">sowder.com</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><a href="https://l.antigena.com/l/RdSR3caVqq3SW2_VvAq3hRRqNHDsfrKvHb6ScFDk8XZeRXOx1Eu9052GqJImy_~xPl_U7uu5TOz1YOOQS8V_8FjaNTSCzJG9AAXDRJd_Fd7g6mkM6QJzckZ4w6myD3AVQNwv87xnWg8V~0pokc4xWsMAo6R~66">blogs.com</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-GB"><o:p> </o:p></span></p>
<p style="margin-bottom:12.0pt"><span lang="EN-GB" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#666666">This electronic message, including any attachments, is intended only for the use of the individual or entity to which it is addressed and
may contain information that is privileged or confidential. If you are not the intended recipient, please notify us immediately by replying to this message and then delete this message from your system. Any use, dissemination, distribution or reproduction
of this message or any attachments by unintended recipients is unauthorised and may be unlawful. We have taken precautions to minimise the risk of transmitting software viruses, but we advise you to perform your own virus checks on any attachment to this message.
We do not accept liability for any loss or damage caused by software viruses. <o:p>
</o:p></span></p>
</div>
<p><br>
<br>
-------------EOP--------------- <br>
<br>
This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment
and delete this communication and any copy. <br>
<br>
Thank you </p>
</body>
</html>