Getting white page with large number of rows

Yup, there is. Look into PHP’s memory_limit directive. Good luck.

Thank you for the response. It seems that our php memory limit is already set to 128mb which is the maximum allowed for the server (Bluehost). Is the memory limit really the problem?

Do you have any other suggestions?

Is it possible to have the script read a csv file hosted on the server? I really want this to work. It is exactly what I need for this website.

Thanks again.

I’m not really sure what the problem is, there’s no information on which to base an analysis.

Here’s a good guide to debugging a blank white screen in WordPress. ?? Good luck.

Turning on debug does not show any errors.

The problem seems to be the amount of rows I am trying to query.

It does seem to be the case that a spreadsheet of that size could be causing a problem, but I can’t troubleshoot your website for you. A blank white screen means WordPress isn’t even managing to output any HTML, which means the problem probably isn’t this plugin because this plugin can’t be invoked until the shortcode gets processed. That means there are errors somewhere. Keep looking and you’ll find them. ?? Again, good luck.

Thank you for your responses. Your plugin is great. It is simple to use. But as it turns out, this plugin is probably not a good idea for use with such a large database, since it seems to be loading all the content at once.

I was able to up the php memory limit to 512mb to get the the database to load, but it took so long to load, it was not useful in any way.

After lots of research and a bit of trial and error, I decided the best way to handle it was to do real server-side processing, by making my own database in MySQL. Then I used a premium plugin called wpDataTables to display the results on the front end. It now works fast and proper the way I needd it to. https://codecanyon.net/item/wpdatatables-responsive-tables-in-wordpress/3958969

Thanks again for your assistance and for writing such a slick plugin. I hope it works for many people. But at least I have offered a solution to anyone looking to display an extremely large database on their website.

You can also use this plugin’s query attribute to retrieve only a subsection of rows from your Google Spreadsheet at a time. I doubt you’re actually displaying 80,000 rows on any one page all at the same time. ?? Regardless, glad you’ve found a solution that works for you.

Hi again, rajaito.

Just wanted to let you and anyone else reading know that I just added a built-in cache to this plugin, available as of version 0.8 of Inline Google Spreadsheet Viewer. This should greatly improve the plugin performance because spreadsheet data can be loaded from the local cache instead of being transmitted over the network from Google each time. All requests that can result in a cache hit (most of them) get a big, big, big speed boost now.

That said, I don’t know if this is precisely what you were looking for to solve your problem, because it sounded like you wanted partial dataset loading. Like I mentioned before, that’s available in this plugin via its query attribute, and these requests also result in a cache hit, so they get the extra speed boost, too. Still, maybe that’s not quite what you were looking for?

In any event, just wanted to follow up here and let folks know that the newest version of this plugin has a new simple caching system.

Thanks again for trying Inline Google Spreadsheet Viewer out. ??

Thanks for following up Meitar. That sounds like a great addition and I wasn’t aware of the query attribute until you mentioned it. I will keep this in mind for future projects for sure.