search

Theophilix / event-table-edit-old

Event Table Edit is a free table plugin for Joomla 3.x to create a responsive, editable table with CSV / XML import and export, and a simple appointment booking system function. Any help in the development is highly appreciated.
GNU General Public License v3.0
10 stars 6 forks source link

Large Data Sets #188

Closed MassEast closed 3 years ago

MassEast commented 3 years ago

First of all, thank you so much for making this Joomla component publicly available for free. It seems to be able to do exactly what I am looking for.

I am currently running into huge performance issues: I imported a ~6300 rows csv file and the site on which I put the table takes minutes to load.

Pagination is on, but that does not seem to help. After some research, I found out that Tabulizer - Large Data Sets seems to be able to cope with such large tables:

Tabulizer can support large data sets, by using a mechanism called data source caching with the server side feature enabled. All source data are eventually stored in a database table for faster filtering and retrieval. As server side feature when enabled, allows Tabulizer to display only the option of the table that's really needed, while keeping the rest of the table data on the server side. The following demo table contains 10,000 rows.

Is there any way to make ETE capable of dealing with such large tables? Or is it maybe already capable but I just didn't find out how?

Thanks!

Theophilix commented 3 years ago

Thanks you for your ideas. Event Table Edit has not been designed for tables larger than maybe 1000 rows. I have never tested it, though. In some months, after having finished more important bugs than this one, I can work on your issue. I am only a hobby programmer with a small time budget.

MassEast commented 3 years ago

Thank you very much for your answer! I guess I will try Tabulizer then, but will switch to a non-commercial method once available. Maybe I could also share code with you, which might help tackling this problem.

MassEast commented 3 years ago

Closed means it is now available resp. will be in Joomla 4 version? Thanks!

Theophilix commented 3 years ago

Well, the migration to Joomla 4.0 and PHP 8 will cost a lot of time and money (I hire freelancer programmers to help me). It will take half a year. I will try to integrate large data sets, but I can't promise it.