<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Alex,<br>
<br>
We've done something similar but in the reverse direction. We set
up triggers on the AS400 files and then used java ODBC drivers to
update the vTiger tables when the AS400 tables are updated.<br>
<br>
Since you have the web services piece built, perhaps a similar
solution would be to use triggers to output changed data or records
to some alternate AS400 file and then use that as your input to the
web service call. That way you are only updating the records and
data that need updated versus updating your entire set up 13000
records?<br>
<br>
<div class="moz-cite-prefix">On 4/23/2018 3:54 PM, Alex Hall wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CA+Q8_JfU3g2tWz3rWGfAefmozRFFJjhoXyuFWui-H9huEk-=Pg@mail.gmail.com">
<div dir="ltr">
<div>
<div>Hello all,<br>
</div>
I have a script in PHP that runs once a day, in the morning.
This script queries the AS400 that stores all our company
data, retrieving a list of all the organizations and their
contacts. There are a little under 13,000 of them, with
anywhere from 0 to 2 contacts per organization. Call it 20,000
web service calls total. It then loops through these records,
using web services to create or update each organization or
contact in Vtiger. Obviously, this is slow.<br>
<br>
</div>
My question is whether there's anything I can do to speed it up.
It takes hours now, and often times out before it completes all
the records. I'm considering rewriting it in Python or another
language that can handle multi-threading, but I don't know if
that's the best way. Are there any ways to speed up web
services? Any tips on using some method over another because
that method is faster, for instance? Are there any server
settings I might try that would give web services more resources
to run faster? Thanks for any advice.<br clear="all">
<div>
<div>
<div>
<div><br>
-- <br>
<div class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div>Alex Hall<br>
</div>
Automatic Distributors, IT department<br>
</div>
<a href="mailto:ahall@autodist.com" target="_blank"
moz-do-not-send="true">ahall@autodist.com</a><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>