Slow product update via csv

[MarlboroMan]

I use a csv file to update my prices and stock, normally it would take about 15min to update before I can re-index all products.

since last night it takes about 6 hours to update and normal products take about 3min to save after editing.

Can you please assist in fixing this?

 

I'm using Prestashop 1.6.1.5

My auto updates are turned off and no changes was made to the site before the problem started.

[Scully]

There was a change of course, maybe one you are not aware of. I would first look into the webservers error logfile.

 

If you are on a shared host, impacts from other users on the same machine are also possible!

[MarlboroMan]

Hi Scully

 

Thanks for the reply

I did ask my host to check but according to them there are no changes.

So far only 100 of my products updated since I posted this Topic.The wierd thing is that the rest of my BO and FO are working like normal.

Is there any other way I can try to find what might cause this as I'm also not receiving any errors at all?

[Scully]

as I'm also not receiving any errors at all?

 

What does mean "receiving". The webservers error logfile does not send out error messages. You have to look into it. Did you do that? If the error logfile doesn't give you a hint:

You could do the following:

 

1. Activate the slow query logfile on your database and see if there are issues caused by the database.

https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html

 

2. Start debugging your program code to find out the reason. This could take some time because at first you have to find the critical functions called. A good way to log into the prestashop logfile would be to use the build in log facility.

PrestaShopLogger::addLog