I am building a website and I need to determine if wpdatatables is the best solution for me. I have a mySQL DB that updates stock market data in real time. If I use sql queries to pull data from mySQL DB into wpdatatables will that data update in real-time or will the screen need to be refreshed?
If I use sql queries to pull data from mySQL DB into wpdatatables will that data update in real-time or will the screen need to be refreshed?
Data will be updated on page refresh, but you can set the auto refresh for the mysql table ( for example every 1 minute) so only the table will be refreshed on the page and not entire page.
I am building a website and I need to determine if wpdatatables is the best solution for me. I have a mySQL DB that updates stock market data in real time. If I use sql queries to pull data from mySQL DB into wpdatatables will that data update in real-time or will the screen need to be refreshed?
Hi William Taft,Thank you for your inquire.
If I use sql queries to pull data from mySQL DB into wpdatatables will that data update in real-time or will the screen need to be refreshed?
Data will be updated on page refresh, but you can set the auto refresh for the mysql table ( for example every 1 minute) so only the table will be refreshed on the page and not entire page.
You can check that feature on our sandbox site
http://sandbox.wpdatatables.com/
Best regards.
Kind Regards,
Miloš Jovanović
milos.jovanovic@tmsproducts.io
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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