Hello,
import CSV activities takes many hours when using import tools,
are there any solution to improve performance ?
Thanks,
Which version ?
How many activities ?
Please give more detail. Importing 1 activity on V9.3.3 is very quick (< 1s)
Which version ?
la version 9.3.3
How many activities ?
environ 2000 activities and takes more thon four five hohours
pease give more detail. Importing 1 activity on V9.3.3 is very quick (< 1s)
Hi,
I just tested on my server, and got import of you file in about 10mn, wich gives a rate of about 200 activities created per minute.
I think your server is quite slow...
Hi,
I just tested on my server, and got import of you file in about 10mn, wich gives a rate of about 200 activities created per minute.
I think your server is quite slow...wich paramètres i should modify to improve performance of the server and time of import csv files. I think in mysql configuration service !! What's paramètres to increase ?
wich paramètres i should modify to improve performance of the server and time of import csv files. I think in mysql configuration service !! What's paramètres to increase ?
Things are not easy.
There is no magic_high_performance parameter for MySql.
Your DB manager should analyse the parameters.
PhpMyAdmin may give hints.
But sometines parameters won't give better performance.
The material may be the bottleneck.
my configuration : 10vCPU, 16G RAM
could you share your configuration Server : RAM, CPU ?
could you share your mysql variables: innodb_*