Posted 3 months ago #
Thanks for the great plugin,
I just created a site for my client. He noticed that the Serch box on the WordPress site does not include any results form the WP-Tables content.
For example, someone searching for specific item included in the table only ends up with the page name and short blurb.
Is it possible to have the table content part of the WordPress search?
Hi,
from your description, this is actually not an issue with WP-Table Reloaded, but with how the theme that your client uses will print the search results. This is independent of whether the search term was found in a table or not.
As the page name and "blurb" (better call it "excerpt") was printed, this means that the integration of the search into WP-Table Reloaded works as expected. You'll need to modify the theme so that it shows the entire post/page content (which will then also render the table).
Regards,
Tobias
Posted 3 months ago #
Thanks Tobias,
That's exactly what I did. The results show full content per page. I have the terms highlighted in the results etc.
The issue here is that the page is so huge that it requires scrolling and looking for the highlighted terms.
What I was thinking instead is to merge all my wine tables into one and give a people option to search within the table using the Table Reloaded Search feature.
Here is my concern. I have about 50 tables built. Some of them holds 200 records some of them just few. What would happen If I have a one bug table with lets say 5000 records.
Is this still going to work efficiently. Am I going to be able to import CSV file with that many records.
Do you see any issues with that many records?
Hi,
I'd go with separate tables here (if you stick to WP-Table Reloaded, more on this in a moment).
WP-Table Reloaded was not really designed for large tables (like thousands of rows), and you might see a drop in performance - and what's even worse, a drop in usability. For example, the "Edit" screen for such a large table will probably be rather useless, and either slow or not loading at all. Import of such large tables could work, but it can also be troublesome.
So, for best efficiency, I would leave the tables separate in WP-Table Reloaded.
Now, however, for what you describe, one large table might indeed be better. Instead of using WP-Table Reloaded for it, you might however want to explore the possibility of some custom PHP code to access a custom mySQL table with your data.
This should then also give you more advanced search possibilities in that data. You could of course also use the search from the DataTables library on that table manually (see http://www.datatables.net). But as that would also require loading the entire table, this could in theory become slow. A custom search in mySQL would probably be the fastest then.
Regards,
Tobias
You must log in to post.
