| Tip |
|---|
Have a tip of your own to share? drop us an email and we will be sure to reward you with some SWAG ;-) |
Eleven years day in, day out with this application and you learn a thing or two. We polled our team and asked them for their top 5 pro moves when using SQL for Confluence and here's what they said:
1. Start with 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 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 will save time and ensure the configuration works.
3. Cache for better performance
If your Confluence pages have many visitors, you can drastically improve performance by caching your SQL Macro to 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. Although there is slightly more upfront configuration work, the performance improvements can be quite significant.
5. The Future is bright
Our favorite pro tip is to leverage the Future Macro on busy Confluence pages with one or more SQL Macros or external calls being made. This macro allows your Confluence users to see some content rendered right away while the server works its magic to present the remainder of the page in its entirety.