I'm working on a site with a lot of traffic, and we're trying to avoid broker queries on meta data as some load tests have caused a server overload.
I'm trying to build a dynamic offers and incentives system, which renders out offer content based on a url variable in various areas of certain pages, using dynamic component template inserts.
To get around the load problem, I want to use an approach where we store all the offers in a component, then get that component by ID at run time, and iterate through the offers in it, checking whether each one is applicable given the URL variable.
The problem is I've not found a way to get a component by id as a data object, and interogate it. I need to be able to get the list of ids from the collection, and then get the various fields from those components.
How would you do this? I can't find any documentation for it. Apologies if this is simple, I'm under quite a lot of pressure and don't have a lot of experience with Tridion.
We're using ASP Java in Tridion 2011 SP1