topic Re: Rest Api - Bad Performance (Slow Problem) in Alfresco Forum

Rest Api - Bad Performance (Slow Problem)

hilal — Tue, 13 Jun 2017 08:40:46 GMT

Hi all,I m using Alfresco Community 5.2. And I added some sites, folders and people by using REST API. But Alfresco Rest Api is running so slowly. For example When I updated just about 1000 site with rest api, This process takes about 40 minutes.How can I do this issue or How can i speed this up ? P

Re: Rest Api - Bad Performance (Slow Problem)

jpotts — Tue, 13 Jun 2017 13:50:08 GMT

Much more detail is needed before we can begin to help. For example:

What is the architecture of your server (where is the database running, where is SOLR running, some idea of hardware and OS).
What API calls are you making?
How are you making those calls (share the code)?
What other traffic is hitting the server while you are doing this?
What is happening on the server in terms of CPU and RAM when you are running your updates?
What is happening on the database, especially database connections, when you are running your updates?
Are you invoking your updates over a network? Could there be bandwidth or latency issues? Are you saturating the network interface with requests?

Re: Rest Api - Bad Performance (Slow Problem)

hilal — Wed, 14 Jun 2017 07:05:54 GMT

I m using solr and mysql database .
I call some API like create site, add membership to sites, inherit permission, calculate node reference, create person, upload documents, etc...I m giving just an example my api methot (addMemebersToSites api method)(this method and other is running for 1000 site for every day)
In code, "client.executeMethod(post)" line is running so slowly. So I received response too late.
private static void addMemebersToSites(String usid,String siteID,String role)
{
HttpClient client = new HttpClient();
String apiurl = api+"alfresco/service/api/sites/"+siteID+"/memberships";
PostMethod post = null;
try {
post = new PostMethod(URIUtil.encodePath(apiurl));
JsonObject person = new JsonObject();
person.addProperty("userName", usid);
JsonObject member = new JsonObject();
member.addProperty("role", role);
member.add("person", person);
post.setDoAuthentication(true);
post.setRequestHeader("Content-Type", "application/json; charset=utf-8");
post.setRequestHeader(HttpHeaders.AUTHORIZATION, pass);
post.setRequestEntity(new StringRequestEntity(member.toString(), "application/json; charset=utf-8", "UTF-8"));

int status = client.executeMethod(post);

if(status == 200 || status==201)
{

System.out.println(status + " " +usid + " is added to this web site");
}
else
System.out.println(status + " " + usid + " can not added to this web site(error)");
} catch (Exception e) {
e.printStackTrace();
} finally {
post.releaseConnection();
}
}