| Tip |
|---|
Have a tip of your own to share? drop Drop us an email and 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 their top 5 pro moves when 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 Macromacro.
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 time and ensure the configuration works.
3. Cache for better performance
If your Confluence pages have many visitors, you can drastically improve performance by by caching your your SQL Macro macro to reduce costly database round trips.
4. Use
...
application server based data source profiles
For larger environments, we strongly encourage we strongly encourage that you configure our app to leverage Application Data Source Profilesleverage application server based 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 the Future Macro on on busy Confluence pages with one or more SQL Macros macros or external calls being made. This macro These macros 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.