Slow import

I’m importing 6000 target and import is relay slow. I’m now on VPS and import on shared hosting was much quicker.

What I need to setup on server to speedup import?

I think I’ve found a reason. The reason is VPS performance, when I importing CPU is on 100%.

Which settings do I need to setup on VPS to speed up import and reduce CPU load?

When I importing eg. targets, importing speed is so slow and VPS CPU is on 100%

How you solve for CPU 100%, I got the same issue?

Please help

maybe your VPS provider gives you only 1 core(thread), ask for more.

best regards

Hi,

I use 8core and 32GB memory. I was try using opcache but still high cpu usage.

Any suggest?

Thank you

I don’t think you’re lacking computer specs, you just need to find out what’s causing the delays, they aren’t normal. Check your logs.

Check out this post by Jim Mackin:
http://www.jsmackin.co.uk/suitecrm/large-imports-in-suitecrm/

Also, you could tell us which version of SuiteCRM you’re using, and how slow are the imports? 1 second per record? 20 seconds per record?

I’m using version 7.6, 60 seconds 100 records. Have you treatment for this issue ?

Thank you

Maybe that’s not so slow. For imports that are “swallowed” by the system one by one, through high-level API’s.

You can just wait it out, 60 minutes should do (I did my imports overnight, each took a few seconds, creating several relationships, etc., through PHP).

If you really need to work on the delays then the article I linked should provide everything you need to know…

Correct, now I try to create script and tweak server. But I have problem again with accessing Application. This my issue https://www.suitecrm.com/forum/suitecrm-7-0-discussion/9306-suitecrm-can-t-lauch