Hi Uvindra On Wed, Nov 16, 2016 at 1:48 PM, Uvindra Dias Jayasinha <[email protected]> wrote: > > > Searching and sorting will be done at DB level via SQL. It is only the > pagination of the returned result set that will be done at Java level. >
So does this mean for different search request you will be caching separate sets of data ? If that is so will it exhaust the memory and how will API search perform under a load. And since the servers will be running on containers available memory would be even less. Why would this be more efficient than Java? We achieve a similar thing by > using a local cache so there is no need to have an intermediate in memory > DB. What was proposed makes sense when you consider that we a dealing with > only a very small amount of data at DB level now. > Considering pagination is done using DBMS, in-memory db will help to work only with a one data set as well as needing to maintain one set of pagination queries. > In the future if we foresee a requirement for DB level pagination we can > implement that within the DAO layer, but for now this is more than enough > to meet our needs. This way we can avoid introducing unwanted complexity > upfront since there is no rationale for doing so. > Agreed, but if the complexity is to support pagination for all the DBMSs we can at-least focus on adding db level pagination for commonly used DBMSs (ie MySQL, Oracle). Regards Jo > > >> Thanks & Regards >> Jo >> >> >> >> >> >> >> >> >> -- >>>> With regards, >>>> *Manu*ranga Perera. >>>> >>>> phone : 071 7 70 20 50 >>>> mail : [email protected] >>>> >>>> _______________________________________________ >>>> Architecture mailing list >>>> [email protected] >>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>> >>>> >>> >>> >>> -- >>> Regards, >>> Uvindra >>> >>> Mobile: 777733962 >>> >>> _______________________________________________ >>> Architecture mailing list >>> [email protected] >>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>> >>> >> >> >> -- >> >> -- >> *Joseph Fonseka* >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: +94 772 512 430 >> skype: jpfonseka >> >> * <http://lk.linkedin.com/in/rumeshbandara>* >> >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > Regards, > Uvindra > > Mobile: 777733962 > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- -- *Joseph Fonseka* WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: +94 772 512 430 skype: jpfonseka * <http://lk.linkedin.com/in/rumeshbandara>*
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
