[Plugin: Users to CSV] memory limit when adding fields to query

This isn’t strictly a support question about this excellent plugin, but Joost, or anyone else who’s worked with this plugin, bear with me if you’ve a second to spare…

I’ve basically used the plugin as the basis for a custom plugin for a client who wants to export the logs for the Download Monitor plugin as a CSV file. I got it basically working, but when they asked for me to add in the filesize, I hit problems.

Obviously, I’ve adapted the main query on line 165 of the original plugin code. I’m adapting the lines around 166-168 to add the filesize column (DLM doesn’t store filesizes so I’m reading them directly from each file).

The basic query works, CSV comes through fine. But as soon as I add a loop to add fields, I break the 64 MB PHP memory limit.

OK, so there’s about 19,000 records coming out of the DLM logs – the CSV file is about 3.5 MB.

Is there a way to do this kind of processing without breaking a 64 MB memory limit? Has anyone had issues with this plugin exporting vast numbers of users? Any tips very much appreciated.

http://wordpress.org/extend/plugins/users-to-csv/