Im new to ERPNext
Im currently testing ERPNext using a virtual box image with 2GB RAM, I successfully uploaded 700,000 rows of records on the tabItem i used Navicat to import the data ERPNext works fine with 60,000 rows of data but now ERPNext is now running slow with 700,000 rows specialy when saving an Item and doesn’t respond when i choose an item in making a quotation. Im planning to upload 3 Million+ rows of item data.
Do i need to adjust my MySQL my.cnf
or i can use frappe / bench to adjust some settings for it to run faster?
What i tried
- item_code,item_name i used numbers from 1-700000 instead of using original item_name and itemcode because i noticed it was using item_name for indexing [still running slow].
- I increased MySQL settings to 150% [still running slow].