| 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:
...
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.
...
If your Confluence pages have many visitors, you can drastically improve performance by caching your SQL Macro , thus reducing to reduce costly database round trips.
...
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.
...