Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
I have multiple charts & tables on a single page. Is there a way to use a single DB connection for these to limit the number of open connections to my DB when the page loads?
Hi Jereme,
I am sorry, but i am not fully understanding this question.
If you use the default SQL WordPress Database, and you did not add any additional /external Database connection, then our Plugin will just pull all your Queries from the same Database.
Or if you added Additional DB Connections in the Main Plugin Settings/Separate DB Connection,
for each Table/ and Chart, the Wizard will ask which DB Connection you will use.
Maybe you mean if you can use a single "Call" to the Server for multiple SQL Queries that would be pulled from your Hosting Server to reduce the load in some way?
If you could just elaborate a bit more on that, and i can check if that is possible, just wanted to make sure we understood the goal first.
And if you can confirm what are the source Table types you use for the Charts.
Are they SQL based or linked from a file such as CSV/Excel/Google sheets or similar?
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
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
Hi Miloš. Yes, I'm asking about using a single 'call' or opening a single DB connection to make a call for each table/chart/query, or even possibly loading the data synchronously so the plugin only opens 1 DB connection at a time.
If I have 2 charts and two datatables on a single page, I'm assuming the plugin is opening 4 concurrent DB connections upon page load. If that is true, my concern is that if I have just a few visitors loading this page at the same time, my host DB connections will be exceeded.
In my case, I'm linking to an existing data source (SQL query).
Hi Jereme,
To begin, I want to extend my heartfelt apologies for the delayed reply,
which is due to an unexpectedly high volume of inquiries.
We truly value your patience during this period.
-
I am honestly not sure if that will be possible, we will ask our developers if there is any workaround you might try in order to somehow use a single call or opening as a single DB connection when you have multiple Tables and/or Charts on same page to avoid having them each do their own 'call' so to speak.
They will certainly have a better understanding how that works and if there is a workaround to achieve it.
As soon as they advise, we will report back right away.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
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
Hi Jereme,
Apologies for all the waiting time again.
We have confirmation after a lot of testing.
I am truly sorry to disappoint you, but we don't have any built-in solution to achieve this.
You can suggest it to our developers - they will do their best to make a solution in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Kind Regards,
Miloš Jovanović
[email protected]
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