Posted 6 months ago #
I'm trying to upload an Excel csv file that's 1.8 MB in size, with about 20,000 rows, 15 columns.
I'm getting the following error when I try to import:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2 bytes) in /home/voiperne/public_html/choochoo/wp-content/plugins/tablepress/libraries/csv-parser.class.php on line 192
Any way to fix this?
What sort of limits are there to table size?
Many thanks.
Hi,
thanks for your post, and sorry for the trouble!
This error means that the available PHP memory limit on your server is reached, so that the table import process could not run successfully.
The only solution I see would be to increase that limit (e.g. by increasing the value of the WP_MEMORY_LIMIT constant with the instructions at http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP )
Now, unfortunately, even if you do that and the table is imported successfully, you like won't have much fun with a table of this size in TablePress. The reason is that the "Edit" screen will basically be unusable (due to the large amount of input fields that the browser has to handle), and due to the large amounts of data (which will be in the area of 1.8 MB) that has to be transferred during EVERY request to edit or even view the table.
So, while TablePress doesn't impose an direct limits on the table size, there are certain limits that arise from things like the PHP memory or speed considerations, as in this case. Therefore, for this table, I would not recommend to use TablePress, but instead look into a custom solution, e.g. based on PHP and mySQL directly.
Regards,
Tobias
You must log in to post.
