Advice system requirement

[item]

Dear Teams,

what's is the advice of system requirement ?
how ram ? how iops ? how cpu ? how tunning ?

we have actually a vps 2vCpu, 2gRam (apache/nginx/php/mariaDb) .. and I have a jobs who inject a csv file with 160K record in espocrm (find, create, relate) with many entity .. but take 8hours. (I use orm)

Can you say me if :
4gb => 3gb mysql and 1gb php is good ?
4vCpu ?

of have you a typical link of the best choose of system requirement ?

Regards

[yuri]

Hi,

There's no such requirements. It depends on how the system is used, how many users, how much data, etc. 8 hours is really a lot.

I tried to import 100K once and it took much less time (maybe 20 minutes, I don't remember). It could be that your VPS doesn't provide enough resources.

[item]

Thanks Yuri,
yes certainly the vps is not enough .. so i have asked for a 4gb and 4vCpu ( before 2gb and 2vCpu).
and not skill , i have asked for have tunning 75%ram for mysql and 25% for php.. i hope i am in right way.
i don't know for import, i have just a 150k record in in csv file.. i have a job..i read each line, split in field (20 fields) .. and make "find, create, relate"..for 4 entity.. never have problem.. work like a charm but 8h...
and i have a service .. who read, create and return a xlsx.. and there i have now a time-out. .. so need config/tunning nginx/apache i think
for me .. i just need best configuration . . minimum VPS requirement .. we are only 3 users

Tommorow.. we have new VPS .. i will stay tunned

Regards