I am a data guy by trade, not a web dev at all. Tableau is my bread and butter with a bit of SQL thrown in, just enough to be dangerous. Friend of mine approached me and asked for a simple site to keep track of availability for some volunteers. Sounded like a fun ‘little’ project so I decided to take a stab at it.
What I currently have setup is a form using WP Data Access Plugin. It updates two VERY simple MySQL tables in the WordPress Database that is included with the hosting service packages. This part works flawlessly. User fills out the form, hits a couple drop downs and \*boom\* tables are updated. Takes less than a second.
The problem is trying to have the end user VIEW those tables. I am currently using the SQL Reports Plugin and it seems to have the best performance and the simplest output, but I am having issues with the output on the page not updating what is in the actual table. I assume it’s being cached somewhere, but I can’t find an option to turn off caching in the plugin.
In addition, loading the page takes 10-15 seconds. No graphics on the page currently, just the form and TWO tables that show the statuses. Those queries run in under 1 second each, there are only around 20 records on the tables that are being rendered when the user loads the page. The rendering of the tables is also as simple as it comes, no custom CSS, no formatting, just SIMPLE.
Am I over complicating this? Is there a better FREE plugin I can use to create a simple table for end users to view the table? I am running up to a deadline and have exhausted my LIMITED WordPress knowledge and Google searching hasn’t been much help.
[ad_2]