[External] qtp bulkfetch swtich

[Herald Kaffka]

Bulkfetch relates to "how many" records to retrieve from the database on each read.  (you may process the records one at a time,
But it helps with network latency if you transfer records in bulk instead of one at a time...

Without seeing any records or code, It's hard to tell exactly "why"  it's failing for you.

"My working Guess" would be that you are working with a very fat record or record complex, and are hitting memory constraints
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.
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).
Basically you are trading memory resources for speed with bulkfetch, but  you do have to have the resources to trade away for that speed...

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
Remote possibility, my money would be on using more memory buffering than you can support for a large transaction...).


From: powerh-l <powerh-l-bounces at lists.sowder.com> On Behalf Of Mark Toms
Sent: Tuesday, August 11, 2020 12:21 PM
To: powerh-l at lists.sowder.com
Subject: [External] qtp bulkfetch swtich

HI All
I am busy looking at the qtp application and why it does not allow me to update table in database ,
I see that current implementation has a default parameter of bulkfetch=1000 .

Would anyone happen to know what the bulkfetch parm is for ?
It is related to relational database tuning , but I don't have specific detail.

  The powerhouse manual I have , does not include it as reference.
When I remove the parm , my update works .


::::::::::::::
qtp
::::::::::::::
# only two parameters required
$PH_USR/bin/qtp cc="(UNIX,$hpaccount)" bulkfetch=1000

::::::::::::::
qtpaudit
::::::::::::::

# only two parameters required
$PH_USR/bin/qtp cc="(UNIX,$hpaccount)"


Bulkfetch reference mentioned in context of tweaking Sybase for powerhouse .
sowder.com<https://l.antigena.com/l/gXm9bcAV3rWrWKY5M-0uluoZD7Gg8ZnWBGG8ZhEoykiSgBoEho_LMq--Tgpz1KFyxam02yzEHGn2h2hR_0pnqZgkirw7oyPorGjCfh8KsP6JF8EmP9wDL2I35GVeeVTAV0Ais9-oCK3bVxszlA7ljASTiN1h1rX>
blogs.com<https://l.antigena.com/l/RdSR3caVqq3SW2_VvAq3hRRqNHDsfrKvHb6ScFDk8XZeRXOx1Eu9052GqJImy_~xPl_U7uu5TOz1YOOQS8V_8FjaNTSCzJG9AAXDRJd_Fd7g6mkM6QJzckZ4w6myD3AVQNwv87xnWg8V~0pokc4xWsMAo6R~66>



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.


-------------EOP---------------

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.

Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20200812/fec154cf/attachment-0001.html>