Hi Dilini, Thanks for the suggestion. I will follow the 1st approach and let you know the progress.
Regards, Dimuth On Mon, Jun 11, 2018 at 6:05 PM Dilini Muthumala <[email protected]> wrote: > Hi Dimuth, > > From the given information, it seems option #1 would be better. This is > because the user validation must happen realtime. > > Joining an input event (authentication request, in this case) against a > table and extracting a result in realtime is a common usecase for SP. > > However we should be cautious about the performance implications of JOIN > operation. For instance, if the size of the table is big, joining might > take sometime. Based on the complexity of the JOIN opertaion (Number of the > authentication requests per second, size of the table etc) we will have to > do performance optimizations. > > Thanks, > Dilini > > On Mon, Jun 11, 2018 at 5:07 PM, Dimuth Menikgama <[email protected]> wrote: > >> Hi all, >> >> I have a custom requirement of publishing a set of attributes to Stream >> Processor in each time a user is successfully authenticated. That event is >> persisted and stored in a relational database via SP app. When the same >> user tries to authenticate for the second time, I need to validate the user >> based on those previously stored data. >> >> AFAIK there are two possible ways to achieve this. >> >> 1. Create an another SP application that receives required >> information as an HTTP post (@source), JOIN that event with the table in >> SP >> application and return desired results as an HTTP response (@sink). >> 2. Create a simple database client that can return desired results. >> >> Are there any special advantages/disadvantages of using those approaches? >> What is the recommended way to do this? >> >> Regards, >> Dimuth Menikgama >> -- >> >> *Dimuth Menikgama* >> >> *Software Engineer* >> *WSO2* >> >> >> *Mobile : + 94 702337977* >> >> > > > -- > *Dilini Muthumala* > Senior Software Engineer, > WSO2 Inc. > > *E-mail :* [email protected] > *Mobile: *+94 713-400-029 > -- *Dimuth Menikgama* *Software Engineer* *WSO2* *Mobile : + 94 702337977 <javascript:void(0);>* * <javascript:void(0);>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
