| Tip |
|---|
Have a tip of your own to share? drop Drop us an email and we will be sure to reward you with some SWAG ;-) |
Eleven years, day in , and day out with , into this application and , you learn a thing or two. We polled our team and asked them for their top 5 pro moves when while using SQL for Confluence and here's what they said:
1. Start with a valid SQL
Where possible, test your SQL using a native database client. This allows you to validate and optimize your query prior to it being used within statements before you use it a SQL Macro.
2. Copy + Paste
When using SQL Macros macros on a page, it's often easier to copy and paste an existing SQL Macro macro and use it as a template. This will save Save time and ensure that the configuration works.
3. Cache for better performance
If your Confluence pages have many visitors, you can drastically improve the page performance by caching your SQL Macro to macro and reduce costly database round trips.
...
For larger environments, we strongly encourage that you configure our app to leverage Application Data Source Profilesapplication data source profiles and data source profiles. Although there is slightly more upfront configuration work, the performance improvements can be quite significant.
...
Our favorite pro tip is to leverage the Future Macro on busy for Confluence pages that are busy with one or more SQL Macros or external calls being made. This macro allows your Confluence users to see render some content rendered right away while the server works its magic to present the remainder of the page in its entirety.
...