Slow import and import freezes when not watching it #1701
Description
Description
I'm trying to import content to my site, but its been pretty slow. I initially had the import files import 5000 entries then switched to 500 and am currently back at the 5000. In the beginning I was able to import about 4000 entries in a day, but currently it only imports a few hundred.
I notice in the Queue Manager the import seems to get stuck in Pending after a bit and I need to refresh the page for it to continue.
We increased the max execution time and the max input vars in the php.ini file.
The import is not updating any entries and I am only using a single id field for the unique identifier.
The current import started with Craft at 5.8.15 and Feed Me at 6.9.0, but we have since updated both to the below
Additional info
- Craft version: 5.8.19
- PHP version: 8.3.25
- Database driver & version: MySQL
- Plugins & versions:
"craftcms/ckeditor": "4.10.0",
"craftcms/feed-me": "6.10.2",
"phpoffice/phpspreadsheet": "^2.0",
"vlucas/phpdotenv": "^5.4.0"