This method takes more time to get the list of taxonomy and it's items from the database which reduces a page performance for each content in our website. How i can improve the page performance.
I think there is a stored procedure runs for every taxonomy in the list to get the taxonomy items. I would like to call this method only when any changes made in top level taxonomy and to call for specific taxonomy that was modified instead of running the stored procedure for every taxnomy in the list.
Could some one please suggest a way to increase the page performance. is there any search api method that works in this way using caching to improve the page performance.
Any help would be much appreciated.