Announcement

Collapse
No announcement yet.

Advice system requirement

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Advice system requirement

    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

  • #2
    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.

    Comment


    • #3
      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


      Comment

      Working...
      X