That file size sounds like you have a lot of rows & columns. Correct?
So typically every host has what’s called a kill switch. So you need to ask them if they can turn that off on their side so you can get this uploaded. I’m not familiar with that host, but hopefully you’re not on a shared server. They’re more apt to not allow it if your are.
If that’s the case you’ll have to cut the files down in size. Typically you can’t write to the database more than 300 rows per minute. That’s pushing the server’s processors.
Thread Starter
misaoa
(@misaoa)
Hello Stef,
For information the csv file contain 32K cells(14 columns and 2334 rows)
At 300 rows per minute it should be down in less than 10 minutes right ?
I’m on a private SQL server with a private DB.
I have access to some settings, (and i maxed most of them)
Here a picture of the settings (sorry its in french i can translate for you if needed)
-
This reply was modified 6 years ago by
misaoa.
Thread Starter
misaoa
(@misaoa)
Ok figured out what’s going on.
In fact ,in the CSV file i have a column for images web link (from FTP).
I tried without this column and it was fast, and i tried only SKU + Images it’s ok too.
Weird.
Thanks for the support anyway
So split the file into 2k rows each or thereabouts for doing the images and see how it goes.
First, get all your products uploaded without images so they have an ID. Although you can use a SKU to match rows as well.
Thread Starter
misaoa
(@misaoa)
2333 products imported in less than 10 minutes without images (10 columns)
171 products imported in 13 minutes with images (11 columns)
2333 SKU + Images (2 columns only ) not yet finished (but 75% in 14 mins).
2333 full 11 columns taken the whole night…
I’m ok with 2 CSV files i don’t have to import images each time i update my catalog 🙂
That’s pretty good. I’ve had sites with a kill switch on take 5 to 6 hours some overnight, which is about normal.
It’s there to protect everyone on the box if shared.
Great job.
Missy a11n
(@m155y5)
Automattic Happiness Engineer
I’m glad you were able to get this worked out! I’m going to go ahead and mark this thread as resolved. If you have any other questions please feel free to start a new thread.
