<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><tt>Hi all,<br>
<br>
I have specific problem with DBIx update (Oracle driver). I need
to update let say 200.000 rows. Each row should have different
number of changed columns. DBIx->update creates request one
by one like this: "update table set column1='value' where id=1".
Query itself is really small (few bytes), but for each query is
created packet. So I have to transfer 200.000 packets. Ping to
DB server is 4ms, what mean that 1000 updates are done in 4
seconds and the job is done in 13 minutes. I need to somehow
decrease number of packets, let say to send more updates at
once. Do you have some idea how to do it? 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>
<br>
Many thanks.<br>
<br>
</tt></font>
<div class="moz-signature">-- <br>
<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;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
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>
<div class="MsoNormal" style="font-family:Arial,sans-serif;"> <b
style="color:#00B0F0">Martin (singer) Spevak</b><br>
<font size="-1"> HPES Software Development Engineer<br>
HPES Network Management Solutions<br>
Location: Galvaniho 7/A, Bratislava, Slovakia<br>
Tel.: +421 2 5752 5390<br>
Email: <a class="moz-txt-link-abbreviated"
href="mailto:martin.spevak@hp.com">martin.spevak@hp.com</a>
</font> </div>
</div>
</body>
</html>