Hi Rukshan, Then thats fine use indexing if you are directly querying data from raw tables( i suppose via gadgets). There is a performance advantage if you use indexing instead of spark analytics, otherwise it is quite costly in storage wise. So its better if you use indexing only for required fields/tables.
Thanks, Malith On Fri, Jul 22, 2016 at 5:20 PM, Rukshan Premathunga <ruks...@wso2.com> wrote: > Hi Malith, > > Yes in 1.10.0 event table index because we can fetch data from REST API. > That was the only reason. Also didn't we get any performance improvements > by indexing those columns? > > Thanks and Regards. > > On Fri, Jul 22, 2016 at 5:15 PM, Malith Dhanushka <mal...@wso2.com> wrote: > >> Hi Rukshan, >> >> Actually i was referring to APIM toolbox ships with 1.10.0 version. Same >> thing applies to APIM analytics as well. >> >> Thanks, >> Malith >> >> On Fri, Jul 22, 2016 at 5:03 PM, Rukshan Premathunga <ruks...@wso2.com> >> wrote: >> >>> Hi Malith, >>> >>> Some event tables are indexed because if there is a requirement to fetch >>> data directly from DAS REST API we can used it without any additional >>> summary tables. >>> >>> @Nirmal, >>> are we using these table to read data directly from REST API other than >>> summary Tables. >>> >>> Thanks and Regards. >>> >>> On Fri, Jul 22, 2016 at 3:26 PM, Malith Dhanushka <mal...@wso2.com> >>> wrote: >>> >>>> Hi APIM team, >>>> >>>> I noticed that event tables(raw data) in APIM statistics are indexed. >>>> Is there any particular reason for that? >>>> >>>> Thanks, >>>> Malith >>>> >>>> -- >>>> Malith Dhanushka >>>> Senior Software Engineer - Data Technologies >>>> *WSO2, Inc. : wso2.com <http://wso2.com/>* >>>> *Mobile* : +94 716 506 693 >>>> >>> >>> >>> >>> -- >>> Rukshan Chathuranga. >>> Software Engineer. >>> WSO2, Inc. >>> >> >> >> >> -- >> Malith Dhanushka >> Senior Software Engineer - Data Technologies >> *WSO2, Inc. : wso2.com <http://wso2.com/>* >> *Mobile* : +94 716 506 693 >> > > > > -- > Rukshan Chathuranga. > Software Engineer. > WSO2, Inc. > -- Malith Dhanushka Senior Software Engineer - Data Technologies *WSO2, Inc. : wso2.com <http://wso2.com/>* *Mobile* : +94 716 506 693
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
