Hi,
I have a component in which through Java external I query LSCS for a specific metadata , say Teamsite/Metadata/Product , and get results as XML , result contains both doc files & .page files. I use the XML result to create links in HTML, setting asset paths in "href" of anchor tags. I want to track the number of clicks of these links & based on that count , I have to put sorting of links , basically put a "Most Viewed" sorting.
I can write Java external ,put it in a page and through that , update the click information in a MySQL database table on every click via AJAX. This way I can keep incrementing the Click counts in the RDMS, with asset path being my unique key.
My problem is fetching that information back from RDMS while generating Links in XSLT. I have the page paths in LSCS results but I cannot query RDMS for each LSCS result as it may overload & carsh the MySQL.
Somehow If I can get the Links counts, in RDMS, as LSCS result then it will be easy to generate Links & set sorting.
What can I do to combine results from LSCS & RDMS ? LSCS deployment happens from Teamsite & RDMS will be updated via JAVA on the runtime, with page paths being the common link between the two.
Is it possible for IDOL in LSCS to index the data in RDMS table based on asset path & add a new Click count Metadata to that asset , so that it is available via simple LSCS query ?
Your thoughts are welcome.
Thanks!
