Have a tip of your own to share? Drop us an email and we will reward you with some SWAG ;-)
Eleven years, day in and day out, into this application, you learn a thing or two. We polled our team and asked them for their top 5 pro moves 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 statements before you use it in a SQL macro.
2. Copy + paste
When using SQL macros on a page, it's often easier to copy and paste an existing SQL macro and use it as a template. This saves time and it is ensured 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 and reduce costly database round trips.
4. Use application data source profiles
For larger environments, we strongly encourage that you configure our app to leverage application data source profiles and data source profiles. Although there is slightly more configuration work, performance improvements can be quite significant. The following table lists where you can find this information:
5. The Future is bright
Our favorite pro tip is to leverage the Future Macro for Confluence pages that are busy with one or more SQL macros or external calls. This macro allows your Confluence users to render some content right away while the server works its magic to present the remainder of the page in its entirety.