I have a C# products page which is using Bazaarvoice API for Idea, ratings on the Products page. Each product has a comment box and rating which is coming from the API. The Unique memeber ID and the product ID is passed to the API to save the Idea. And using the member ID and the product ID to get the result.
The process is working fine but its very slow. For example if i have 200 products and if i open each product detail then a request is made to the bazaarvoice api using Member ID and Product ID and it retus the data which is displayed on the product details page. So for 200 products ,there are 200 api calls are made to the API.
I am thinking to make a single call based on memeberID and product ID and save them somewhere and then each product detail will access the list to get the Idea. I am not sure what is the best approach to do it. Should i create a JSON file of all records and then access the relevant record based on the product ID and Memeber ID or should i use the XML to store the data or Cache is an ideal option.
Please any help would be appreaciated.
Thanks