1.8.1 is not the latest. Regardless, the next version will have a much faster import, but I’m not completely finished with it yet.
Thread Starter
cgold
(@cgold)
Sorry I double checked and I have 1.8.3. Do you have any eta when the next update would be released? Thanks Many
Hopefully tomorrow or Saturday.
Hi Shane or colleague,
For what it’s worth, I’m seeing identical symptoms with 1.8.3. Ad-hoc optimization works fine, but bulk optimize just shows a spinning “importing” icon after clicking on the import button.
If I can help with a log or anything, please just let me know…
Cheers,
David
dwood, thanks for the feedback. The problem is that the import is a very sql-intensive operation (lots of tiny disc reads & writes), so I’m working on optimizing that. The process flow looks something like this in 1.8.3:
1. get the image metadata (a read from the disk)
2. check the ewwwio_images table for an entry (another read from the disk)
3. create/update the record for the image in the ewwwio_images table (a write operation, which is typically more intensive).
Repeat this once for every image in WordPress, and it can take a looooooong time.
The new process is going to look like this:
1. get the image metadata for all images at once
2. retrieve all the entries in the ewwwio_images table
3. do updates on demand, but do record creation in batches of 100+
For something like 10,000 images, this will result in 2 read operations, and 100 write operations, a HUGE improvement over the previous process.
The last step thing I have to implement is the multi-record INSERT statements. Going to work on that this morning hopefully so I can get it pushed out by tomorrow at the latest.
1.8.4 with 50x faster import has landed!
Hi Shane,
Hmmm, still no joy with 1.8.4, same symptoms, namely:
– Go to /wp-admin/upload.php?page=ewww-image-optimizer-bulk .
– Click on “Import images”.
– Status msg “Importing” and a spinning circle.
Media library size is 2,300 images, so not huge.
If there’s any way I can help with debugging or whatever, please just let me know…
Thanks,
David
Thread Starter
cgold
(@cgold)
Hi, David. I have updated to the latest version 1.8.4 and its still spinning on import.
Yeah, that amount of images should NOT be causing timeouts at all. Should take like 2 seconds or less. I would check the javascript console to see if there are any errors. Perhaps the import itself isn’t even firing due to a plugin conflict.
You can use Firebug for Firefox, or the built-in developer tools for Chrome.
I would also check your server error logs, and try turning on debugging in wp-config.php to see if that turns up anything useful.
If none of that is helpful, disable all other plugins, and try the Import to see what happens.
I installed 1.8.4 but when importing images for bulk optimization I quickly get this error:
Fatal error: Out of memory (allocated 56623104) (tried to allocate 32 bytes) in xxxxxx/wp-includes/wp-db.php on line 1565
I know our hoster isnt exactly generous with memory (“up to 120MB” seems to really mean “less than 70MB”) but I have not had out of memory errors with other plugins.
DLT95, can you please start a new thread? While this MAY be a similar issue, it’s best practice to start your own thread until we actually confirm that two issues are the same thing. We don’t currently have any idea exactly what is giving dwood and cgold problems.
cgold, and dwood, I think I’m on to something that I stumbled across when looking into the memory issues DLT95 reported. I’ll do some more checking in the morning.
Thread Starter
cgold
(@cgold)
I have checked chrome developer tools and i didnt see any errors related to optimizer. If you want wp-admin access I can provide it to you I just need a way to send you a private message with the details.
cgold, did you check your server error logs and/or turn on debugging in wp-config.php??
