Hi, i have a few questions. sorry for the trouble.
1) when I sort a column, the first order wpdatatables chooses is the ascending order (from low to high). Is there a way to reverse this and have it as my default?
I have a bunch of numbers that are usually best analyzed when listed in the descending order, and it's a pain to have to click the header cell twice to see my numbers in a descending order.
2) i think sorting takes too long for a table that has hundreds of rows. when i click on the header cell, i think it takes 3~5 seconds. And then I have to click on the cell twice to reverse the order. So it's becoming very inefficient. Am I doing something wrong or do I have to live with it?
3) I have a table that is linked to a googlespreadsheet that has numbers that change constantly. So when I load my wpdatatable, it always shows different numbers. The problem is that there are thousands of cells in that table, and 1) it takes very very long to load the table 2) very often many numbers simply don't appear at all, leaving whole legions of columns empty. When I refresh the page though, they will sometimes appear, but they may not. It's a bit confusing. I can see why it may take long to load the numbers, but for them to not appear at all is a bit disappointing. Would there be a way to fix this? A mySQL table might work, but (aside from the fact I'm totally ignorant of how how mysql works) I don't think they will reflect values that change constantly.
1. You can choose one column which will be used for default sorting of the table, and in there you can choose whether sorting will be ascending or descending:
2. The speed of the plugin mostly depends on the amount of data in the table, the type of the table, hosting plan and server performance. What's the table type you're using, and how much data is there in the table?
3. When using Google Spreadsheets as the data source please note that the data is read from the data source every time the page loads, so when your tables are large (more than 2000-3000 cells) this source won’t be the right choice since the page with large tables will load slow, or even crash after reaching a certain size. Also, there is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
If you go for SQL query based tables, values added in the database will appear in the table as soon as the table is refreshed, and since SQL query based tables use server-side processing when they pass 2.000 rows, you can create tables with millions of rows.
Please note, though, that creating custom SQL queries is not included in the provided support for the plugin, so I wouldn't be able to help you with that.
Hi, i have a few questions. sorry for the trouble.
1) when I sort a column, the first order wpdatatables chooses is the ascending order (from low to high). Is there a way to reverse this and have it as my default?
I have a bunch of numbers that are usually best analyzed when listed in the descending order, and it's a pain to have to click the header cell twice to see my numbers in a descending order.
2) i think sorting takes too long for a table that has hundreds of rows. when i click on the header cell, i think it takes 3~5 seconds. And then I have to click on the cell twice to reverse the order. So it's becoming very inefficient. Am I doing something wrong or do I have to live with it?
3) I have a table that is linked to a googlespreadsheet that has numbers that change constantly. So when I load my wpdatatable, it always shows different numbers. The problem is that there are thousands of cells in that table, and 1) it takes very very long to load the table 2) very often many numbers simply don't appear at all, leaving whole legions of columns empty. When I refresh the page though, they will sometimes appear, but they may not. It's a bit confusing. I can see why it may take long to load the numbers, but for them to not appear at all is a bit disappointing. Would there be a way to fix this? A mySQL table might work, but (aside from the fact I'm totally ignorant of how how mysql works) I don't think they will reflect values that change constantly.
thank you in advance.
Hello IW
Thank you for your purchase.
1. You can choose one column which will be used for default sorting of the table, and in there you can choose whether sorting will be ascending or descending:
2. The speed of the plugin mostly depends on the amount of data in the table, the type of the table, hosting plan and server performance. What's the table type you're using, and how much data is there in the table?
3. When using Google Spreadsheets as the data source please note that the data is read from the data source every time the page loads, so when your tables are large (more than 2000-3000 cells) this source won’t be the right choice since the page with large tables will load slow, or even crash after reaching a certain size. Also, there is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
If you go for SQL query based tables, values added in the database will appear in the table as soon as the table is refreshed, and since SQL query based tables use server-side processing when they pass 2.000 rows, you can create tables with millions of rows.
Please note, though, that creating custom SQL queries is not included in the provided support for the plugin, so I wouldn't be able to help you with that.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables