<html 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 name=Title content=""><meta name=Keywords content=""><meta http-equiv=Content-Type content="text/html; charset=utf-8"><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;}
/* 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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.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></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Have you considered NOT coding this? Seems to me a properly formatted export of your data could be imported into your application anynumberof ways and would be significantly faster and not bog your application down.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:12.0pt;color:black'>From: </span></b><span style='font-size:12.0pt;color:black'><vtigercrm-developers-bounces@lists.vtigercrm.com> on behalf of Alex Hall <ahall@autodist.com><br><b>Reply-To: </b><vtigercrm-developers@lists.vtigercrm.com><br><b>Date: </b>Monday, April 23, 2018 at 3:56 PM<br><b>To: </b><vtigercrm-developers@lists.vtigercrm.com><br><b>Subject: </b>[Vtigercrm-developers] Speeding up web services sync script?<o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><div><p class=MsoNormal>Hello all,<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>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.<o:p></o:p></p></div><p class=MsoNormal>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><o:p></o:p></p><div><div><div><div><p class=MsoNormal><br>-- <o:p></o:p></p><div><div><div><div><p class=MsoNormal>Alex Hall<o:p></o:p></p></div><p class=MsoNormal>Automatic Distributors, IT department<o:p></o:p></p></div><p class=MsoNormal><a href="mailto:ahall@autodist.com" target="_blank">ahall@autodist.com</a><o:p></o:p></p></div></div></div></div></div></div></div><p class=MsoNormal>_______________________________________________ http://www.vtiger.com/<o:p></o:p></p></div></body></html>