| 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 so . This allows you can to validate the syntax and optimize the your query before embedding prior to it being used within a SQL Macro.
2. Copy + Paste
If you are planning to include more than one SQL statement SQL Macros on a page, then it's often easier to copy+paste an existing SQL Macro and use it as a template. This will save you time and ensure that your configurations are in proper order. You can do this by editing the Confluence page and highlighting the Macro bodythe configuration works.
3. Cache for better performance
...
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
Of all the Pro Moves we observe in the wild, we love when our customers Our favorite pro tip is to leverage the Future Macro on busy Confluence pages with one or more SQL Macro Macros or external call calls being made. This provides macro allows your Confluence users with a pleasant experience to see some content rendered right away while the server works its magic to present the remainder of the page in its entirety.