Hi Ian,
Thank you for your purchase.

Do you have any file so you can send me so I can try to reproduce the issue on my side.

Also this can be issue with the server performance so be sure to check that also.

Best regards.

HI Ian,

Can you please send me the sql version of this file or zip so I can import it to my database and try to see the performance.

When you have a complex queries like that our suggestion is to make a VIEW in phpmyadmin or any other database management system. If the query is returning the desired result you can use that query 
(SELECT * FROM VIEW) as an input when creating tables from Add from data source option.

Hope this can help you.

Best regards.

HI Ian

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Also point me to the table ID so I can take a look.

About the VIEW you can take a look at this link.

Best regards.

HI Ian,

Looking at the query i think the best option is a creating a VIEW.
So can you please try to do that and tell me the result.

Here is another link in case you need it to see how you can create it.

Also I was not able to access your site it is just loading. 

Best regards.

Hi Ian,

Can you please check this page and tell me the result.

Here is my result 2.61 seconds ( attachment) 

Best regards.

Hi Ian,

Unfortunately I can not access your site again. It is still loading.

Can you please investigate that.

Best regards.

Hi Ian,

I can access your site page but I can not access your WP dashboard at all. ( attachment)

Can you please tell me when is the best time to login to your site because it looks like there is some maintenance mode every time I am logged in.

Best regards.

Hi Ian,

I logged in successfully now.

Can you please tell me is it possible for you to provide me phpmyadmin credentials so I can take a look something in the database and try to create a VIEW from your query because I thing the issue of the long loading page might be the in the query.

It can take this much time ( in this case 37seconds) in communication with the server when the query is this big.

Best regards.

Hi Ian,

It looks like the "issue" is in the query.

I tried to make a view from your query but I get this error in the phpmyadmin ( attachment)

Because the query is complex and server needs some time to read the query that can be the reason why it takes too long to load and display the whole table on the page.

Also can you please tell me did you try to make a table from the 5th option in the table wizard.
 ( attachment 2) 

Best regards.

HI Ian,

This is the documentation about the 5th option.

Also we have a clients that are using almost 4-10 million entries without any issues.

Here is also a link where you can see how you can create large tables using mysql.

Best regards.

Hi Ian,

Before I answer to your questions below can I suggest you, in testing purposes to try to change the theme and tell me the result.

Loading speed depends on the server performance so any upgrade ( if can be free) is recommended.

Best regards.

Hi Ian,

1.

    a. Updating the version of mySQL to the newest version?

This is recommended to update the mySQL version, so yes.

    b. Upgrading the VPS that the website is being hosted on? If this would help, what specifically should I be upgrading? RAM, Drive etc. 

Let's try to see the current configuration that I listed below so we can know which settings are set for now.

2. In other words is it the number of records or the number of columns that sets the table load speed?

The loading speed depends on the number of the columns and the number of rows but in case you have less then 2000 rows try to turn off server side option.

Here is mine settings from the wpdatatable settings page

Also can you please tell me the values that you set for memory_limit, post_max_size, max_execution_time  and max_input_time?

This is our set

memory_limit = 256M 

post_max_size = 128M 

max_execution_time = 300

max_input_time = 300

Other issue might be that maybe you hit your MySQL limit with the possible values from your table.

Let me know your setup.

Best regards.

Hi Ian,

Everything seems good.

Can you please increase this values in your file

post_max_size = 128M 

max_input_time = 300

And also try to update the PHP version to 7 or more.

Best regards.

HI Ian,

The mysql update should increase the performances of the loading so can you please do that and see the result.

About the number of the columns.
We did not encountered with this issue but if you want I can try to make a table with more then 10 columns to see if the issue is with that number of columns.

Best regards.

HI Ian,

No problem at all.

As for the 10 columns I created a table with more then 10 columns ( attachment  ) and it is working without any issue.

Now I am thinking maybe you hit the mysql limit for the number of characters with the column names but if that is the case you shouldn't be able to see the table at all.

Are there any more files that you can send me so I can import it to my database and try to recreate the issue.

Best regards.  

Hi Ian,

Unfortunately I do not have installed pods on my machine.

Is there any other way that I can try to reproduce the issue on my side.

Best regards.

HI Ian,

Thank you for the link.
I spoke to my team about the pods public and some of their experience is that the pods plugin is heavily related to the server performance and it is very requirable.

Suggestion is to try to optimize the query but still there is a possible issue for server to "burn".

Best regards.