<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Aug 20, 2015 at 8:11 AM, Martin Spevak <span dir="ltr"><<a href="mailto:martin.spevak@hp.com" target="_blank">martin.spevak@hp.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<font size="-1"><tt>Hi all,<br>
<br>
[edit] I need
to update let say 200.000 rows. Each row should have different
number of changed columns.</tt></font></div></blockquote><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div text="#000000" bgcolor="#FFFFFF"><font size="-1"><tt>[edit] I don't care if update
is success or not. Some kind of bulk update. My idea was to send
all UPDATE queries as strings into storage procedure (let say
per 10 queries). So I try to get this query from DBIx somehow as
ResultSet->as_query (but this is not possible for update
command).<br>
<br>
Do you have any other ideas, how to send few update commands in
one packet?<br></tt></font></div></blockquote><div><br></div><div>I think you're on a good path.</div><div><br></div><div>Send a data structure to a stored proc.<br>execute stored proc using literal SQL "EXECUTE foo() ....."</div><div><br></div><div>Since you don't care about results, it's fire and forget. </div></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Len Jaffe - <a href="mailto:lenjaffe@jaffesystems.com" target="_blank">lenjaffe@jaffesystems.com</a> </div><div>614-404-4214 <a href="https://www.twitter.com/lenJaffe" target="_blank">@LenJaffe</a> <a href="http://www.lenjaffe.com/" target="_blank">www.lenjaffe.com</a><br></div><div>Host of <a href="http://www.meetup.com/techlifecolumbus/" target="_blank">Code Jam Columbus</a> - <a href="https://www.twitter.com/CodeJamCMH" target="_blank">@CodeJamCMH</a></div><div><div>Curator of <a href="http://www.lenjaffe.com/AdventPlanet/" target="_blank">Advent Planet</a> - An Aggregation of Online Advent Calendars.<div><br></div></div></div></div></div></div></div></div></div>
</div></div>