Hi Ishara, Agreed, if we can be sure that things will behave well in high load.
Cheers, Ruwan On Fri, Oct 2, 2015 at 2:24 PM, Ishara Karunarathna <isha...@wso2.com> wrote: > Hi Ruwan, > > On Fri, Oct 2, 2015 at 1:09 PM, Ruwan Abeykoon <ruw...@wso2.com> wrote: > >> Hi Ishara, >> >>In Identity server we started to persist session date with its updated >> timestamp. And retrieve the latest data object related to >> given session. >> >>If it's only supported for seconds we get duplicate entries. In that >> case we have to go for fractional seconds in timestamp >> or will have to store it in another data type. >> >> I think tying up with timestamp for any uniqueness is going to be >> problematic even if we select the most granular time resolution provided by >> the hardware. >> > Thats true and its depend on the use case too. > In our use case we don't depend only on the timestamp and we can't expect > nano second level time different between session participants. > In that case I believe we can go ahead with our approach. > > Thanks, > Ishara > >> For example lets say an IoT device sends more than one request in >> fraction of nano second and this might be causing problems down the >> pipeline/in the future. >> So I would suggest a changing the dependency of using timestamp for any >> uniqueness/ latest check by adding/appending a sequence number, if it is >> the case. >> >> Cheers, >> Ruwan >> >> >> On Fri, Oct 2, 2015 at 10:05 AM, Ishara Karunarathna <isha...@wso2.com> >> wrote: >> >>> Hi Shankar, >>> >>> On Thu, Oct 1, 2015 at 9:54 PM, Selvaratnam Uthaiyashankar < >>> shan...@wso2.com> wrote: >>> >>>> Is this support (fraction of second) there in other RDBMS (Oracle, >>>> MSSQL, etc?). If it is only Mysql 5.6.4 +, then we shouldn't use IMO. If >>>> this support is there in all other RDBMS, then it should be ok. >>>> >>>> I checked with Oracle, MSSQL, PostgreSQL, Informix and DB2. All >>> support for fraction of seconds. >>> >>> Thanks, >>> Ishara >>> [1] >>> http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements001.htm#i54330 >>> [2] https://msdn.microsoft.com/en-us/library/ms187819.aspx >>> [3] http://www.postgresql.org/docs/9.1/static/datatype-datetime.html >>> [4] >>> https://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_110.htm >>> [5] >>> https://www-304.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.intro/src/tpc/db2z_datetimetimestamp.dita >>> >>>> On Thu, Oct 1, 2015 at 9:40 PM, Ishara Karunarathna <isha...@wso2.com> >>>> wrote: >>>> >>>>> Hi Shankar, >>>>> >>>>> On Thu, Oct 1, 2015 at 7:45 PM, Selvaratnam Uthaiyashankar < >>>>> shan...@wso2.com> wrote: >>>>> >>>>>> Normally, we should keep the compatibility with older versions. >>>>>> >>>>>> Is there any specific reason why you need upto microsecond precision >>>>>> for the timestamp? >>>>>> >>>>> by default mysql support for seconds. >>>>> In Identity server we started to persist session date with its updated >>>>> timestamp. And retrieve the latest data object related to >>>>> given session. >>>>> If it's only supported for seconds we get duplicate entries. In that >>>>> case we have to go for fractional seconds in timestamp >>>>> or will have to store it in another data type. >>>>> >>>>> Thanks, >>>>> Ishara >>>>> >>>>>> >>>>>> On Wed, Sep 30, 2015 at 10:35 PM, Ishara Karunarathna < >>>>>> isha...@wso2.com> wrote: >>>>>> >>>>>>> Hi all, >>>>>>> >>>>>>> For example In mysql version 5.6.4 (released on February 5, 2013 ) >>>>>>> onwards [1] it support for >>>>>>> fractional seconds for TIMESTAMP values, with up to microseconds (6 >>>>>>> digits) >>>>>>> >>>>>>> But if we write scripts to get that features it won't work with >>>>>>> older versions. >>>>>>> So can we write scripts to work only with mysql version 5.6.4 and >>>>>>> latest or should we support for old versions ?. >>>>>>> >>>>>>> Thanks, >>>>>>> Ishara >>>>>>> >>>>>>> [1] >>>>>>> http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html#mysql-nutshell-additions >>>>>>> -- >>>>>>> Ishara Karunarathna >>>>>>> Senior Software Engineer >>>>>>> WSO2 Inc. - lean . enterprise . middleware | wso2.com >>>>>>> >>>>>>> email: isha...@wso2.com, blog: isharaaruna.blogspot.com, >>>>>>> mobile: +94717996791 >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> S.Uthaiyashankar >>>>>> VP Engineering >>>>>> WSO2 Inc. >>>>>> http://wso2.com/ - "lean . enterprise . middleware" >>>>>> >>>>>> Phone: +94 714897591 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Ishara Karunarathna >>>>> Senior Software Engineer >>>>> WSO2 Inc. - lean . enterprise . middleware | wso2.com >>>>> >>>>> email: isha...@wso2.com, blog: isharaaruna.blogspot.com, mobile: >>>>> +94717996791 >>>>> >>>> >>>> >>>> >>>> -- >>>> S.Uthaiyashankar >>>> VP Engineering >>>> WSO2 Inc. >>>> http://wso2.com/ - "lean . enterprise . middleware" >>>> >>>> Phone: +94 714897591 >>>> >>> >>> >>> >>> -- >>> Ishara Karunarathna >>> Senior Software Engineer >>> WSO2 Inc. - lean . enterprise . middleware | wso2.com >>> >>> email: isha...@wso2.com, blog: isharaaruna.blogspot.com, mobile: >>> +94717996791 >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> >> *Ruwan Abeykoon* >> *Architect,* >> *WSO2, Inc. http://wso2.com <http://wso2.com/> * >> *lean.enterprise.middleware.* >> >> email: ruw...@wso2.com >> > > > > -- > Ishara Karunarathna > Senior Software Engineer > WSO2 Inc. - lean . enterprise . middleware | wso2.com > > email: isha...@wso2.com, blog: isharaaruna.blogspot.com, mobile: > +94717996791 > -- *Ruwan Abeykoon* *Architect,* *WSO2, Inc. http://wso2.com <http://wso2.com/> * *lean.enterprise.middleware.* email: ruw...@wso2.com
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev