Can’t create table with 45,000 rows.

  • Resolved johnnybach4

    (@johnnybach4)


    8 years, 6 months ago

    I’m sure that this must have been asked before but I didn’t recognise any questions or answers that helped me, sorry.

    Basically, I need to create a table with 45,000 rows and 7 columns, from a CSV file (size just over 4MB) converted from a single Excel 2016 sheet/page. I assume that TablePress can’t handle such a large amount of data – am I correct and should I try something else? I did try creating a small table and appending extra data to it but it’s time-consuming as the program slows down more and more.

    I don’t get very far (not even 1,000 rows worth) before I get “Webpage not Responding ……Recover webpage”. Eventually I get “Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 3531798 bytes) in /home/johnsonm/public_html/johnsontwo.uk/wp-includes/post.php on line 3142.”
    The above address is NOT the full, correct one as, is so, it would give access to a private server which is not to be accessed.

    I’ve tried using WordPress on three different hosting sites (one the permanent site and two just for trial purposes) with exactly the same result.

    Be grateful for any help.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Sounds like you’re running into a PHP memory issue. Try adding the following to wp-config.php define( 'WP_MAX_MEMORY_LIMIT' , '512M' ); – change the value as necessary.

    Thread Starter johnnybach4

    (@johnnybach4)

    Thanks Jay,

    From my limited knowledge, that’s exactly what I think. Unfortunately I don’t have total administrative rights over this WordPress website but will email those who do and put pressure on them.

    Thanks again,

    John

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Yeah, increasing the WP memory limit might help, but even then, you will probably run into slowness. Not only would loading the table on the frontend take long, but the “Edit” screen will also be unusable (due to the high amount of text input fields there).

    For tables of this size, I therefore suggest to use a real database table, with custom code, e.g. PHP, to retrieve desired entries and render them as a table.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can’t create table with 45,000 rows.’ is closed to new replies.