WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Limit of rows with a thumbnail each row (6 posts)

  1. Francesco01
    Member
    Posted 8 months ago #

    Dear Tobias,

    I am using your excellent plugin to create a Digital Library.

    I have searched on the support posts for info regarding the maximum number of rows that TablePress can handle and found that 3000 - 5000 rows could be ok.
    However, as you see here: http://www.arietobertoia.org/wp/?page_id=234 our tables contain one thumbnail for each row.

    Would this reduce the limit of the rows that can be handled?
    Would it make a difference to use only a limited number of fixed icons (e.g. same icon for all books, same icon for all newspapers ...) instead of different (individual) thumbnails?
    Would a reduced size of the thumbnail / icon make a difference?

    Thanks a lot and best regards,

    Francesco

    http://wordpress.org/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    Hi,

    thanks for your question.

    The mentioned limit for the numbers of rows is twofold here: One has to distinguish between limits on the "Edit" screen and on the frontend.

    For the handling and performance on the "Edit" screen, the thumbnails do not play a role. They are treated as pure HTML code which again is treated as text.

    On the frontend, this is different though. There, TablePress will always load all rows of the table first, before applying the pagination and other functions.
    It might therefore (depending on the browser) be possible that more images are loaded than necessary. Therefore, a reduced file size (i.e. width/height are not that important) could lead to faster loading.
    However, if you are concerned about performance, better results should be possible with a different server side loading. For example, you could develop custom scripts that only load the necessary data from a mySQL database.

    Regards,
    Tobias

  3. cdpinc
    Member
    Posted 8 months ago #

    Hi Tobias,
    Related to the above question regarding the number of rows possible on the "Edit" screen, is there a way to increase what TablePress can handle? So far, 1,000 rows appears to be the most I can get to import from a CSV file.

    I have a few tables that contain more than 5,000 rows and I would like to be able to present them without breaking them up into separate tables.

  4. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    Hi,

    thanks for your question, and sorry for the trouble.

    The CSV import problem is actually different to the "Edit" screen problem. For the import, there's most likely a server problem, like the PHP memory limit being reached.
    To work around this, splitting the table into smaller chunks can actually help: You can then use the "Append" functionality on the "Import" screen to merge them to a big table again.
    However, you'll then run into the problem of the "Edit" screen being slow (with 5000 rows on them), and unfortunately, I don't have a fix to that yet.

    Regards,
    Tobias

  5. cdpinc
    Member
    Posted 8 months ago #

    OK, we'll make do with workarounds until a fix is available. Thanks.

  6. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    Hi,

    I forgot one thing for the import issue: You could try to fix that by increasing the WP/PHP Memory limit, by following the instructions at http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
    With that, you might be able to upload/import the full table at once.

    Regards,
    Tobias

Reply

You must log in to post.

About this Plugin

About this Topic