We are currently working on a solution in which we want to track (for analysis) articles that the user clicks on / opens and “likes” from this list of articles. Subsequently, the user should be able to see and re-click / open the article (no search required) in the section dedicated to his / her personal user profile. Somewhere around 100 new articles are published every day. The increase (!) In the number of daily visitors (users) is about 2000 per day. Articles are currently stored and maintained in MySQL Db.
We could create a new entry in MySQL Db for each article read / "liked". "In the worst case" this will create (2500 * 100 =) 250,000 entries per day. Of course, this will not last long ... So, how could you store (process) this in XPages, given the scenario?
My thoughts after reading the "article" :) about MIME / Bean s : how about saving 'read articleObjects' in the area and (periodically) saving / saving them as MIME in the user profile document? This creates only 100 articleObjects per day (or 36500 per year). In addition, it would be possible to create a mechanism in which articleObjects move from one field to another over time, so the active area would only contain “read articleObjects” for the last month or so.
Dalie source
share