5000 records export = php error exhausted

  • Resolved webloft

    (@webloft)


    5 years, 1 month 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)

  • 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.