thanks a lot for the feedbacks.. On Tue, Nov 18, 2014 at 12:15 PM, Srinath Perera <[email protected]> wrote:
> I also think Udara's idea is good. > > On Fri, Nov 14, 2014 at 11:49 PM, Udara Liyanage <[email protected]> wrote: > >> Hi, >> >> So every time an app is accessed the incremented counter needs to be >> written to db. Isn't it an considerable overhead if apps are accessed >> frequently. How about keeping the counter in a cache or write to db say for >> every 10 times(a meaningful value) an app is accessed? >> >> Touched, not typed. Erroneous words are a feature, not a typo. >> On Nov 14, 2014 5:20 PM, "Lahiru Cooray" <[email protected]> wrote: >> >>> Hi all, >>> >>> I'm trying to add a new feature to AppManager to unable user to *sort* >>> the subscribed Apps by accessed frequency. >>> >>> In the back end there will be a counter used to store the no of hits per >>> App against each subscriber. When a subscriber access an App (via >>> AppManager gateway end point URL) the counter will be increased. >>> >>> [image: Inline image 3] >>> >>> >>> And in the front end there will be two options that user the can select. >>> (recently added Apps/ most frequently accessed Apps) >>> >>> *Proposed table structure:* >>> >>> *CREATE TABLE APPMGR_APP_HIT_TOTAL* >>> *(* >>> *API_ID INT(10) NOT NULL,* >>> *USER_ID VARCHAR(50) NOT NULL,* >>> *HIT_COUNT BIGINT,* >>> *PRIMARY KEY (API_ID,USER_ID)* >>> *)* >>> >>> Highly Appreciate your feedbacks. >>> >>> -- >>> *Lahiru Cooray* >>> Software Engineer >>> WSO2, Inc.;http://wso2.com/ >>> lean.enterprise.middleware >>> >>> Mobile: +94 715 654154 >>> >>> _______________________________________________ >>> Architecture mailing list >>> [email protected] >>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>> >>> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > ============================ > Srinath Perera, Ph.D. > http://people.apache.org/~hemapani/ > http://srinathsview.blogspot.com/ > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- *Lahiru Cooray* Software Engineer WSO2, Inc.;http://wso2.com/ lean.enterprise.middleware Mobile: +94 715 654154
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
