5000 records export = php error exhausted

  • Resolved webloft

    (@webloft)


    6 years, 7 months ago

    Hello World !!

    We have 5000++ records, when we try to export we have a PHP error (Fatal error: Allowed memory size of 268435456 bytes exhausted /wp-includes/wp-db.php).

    All data are insert into “postmeta” table (330Mo).

    Any toughs ? I think we will have to built our own query to export all data, we absolutely need those data in a csv file.

    SUGGESTION : The plugin elementor-contact-form-db should use is own table, postmeta table should not be use to get so many data.

Viewing 1 replies (of 1 total)
  • Sean Barton

    (@seanbarton)

    6 years, 2 months ago

    Hi there, it’s a server issue I’m afraid not a plugin one. I know this was posted months ago but changing the table won’t make any difference to the speed of export. I work with sites where that table is several GB and millions of rows.. that’s what MySQL was designed for 🙂

    The memory limit on your site looks to be in the region of 256mb.. just change it to 512 and you’ll get the export fine.

    thanks
    Sean

Viewing 1 replies (of 1 total)

The topic ‘5000 records export = php error exhausted’ is closed to new replies.