Hi Sumedha, Alright but this SELECT is across different tables, and I also happened to find this, [1]. So, unless you are in a transaction, if somebody updates while you read, you can end up having messed up data right?
[1] http://stackoverflow.com/questions/1976686/is-there-a-difference-between-a-select-statement-inside-a-transaction-and-one-th Thanks, Senaka. On Mon, Aug 18, 2014 at 11:29 PM, Sumedha Rubasinghe <sume...@wso2.com> wrote: > Senaka, > I don't think doing a SELECT inside transaction here is required. We just > read the committed data @ the time of reading. That's it. > > We never SELECT records for UPDATES (which is one occurrence where doing a > SELECT inside transaction is useful). Another common usecase if to read > uncommitted data. > > But we use neither of these scenarios. So I believe there is not need to > read within transaction blocks. > > > > > On Tue, Aug 19, 2014 at 3:49 AM, Senaka Fernando <sen...@wso2.com> wrote: > >> Hi Subash, >> >> Ah! forgot to discuss this today when we chatted. >> >> Subash the get() itself is a call spanning across multiple tables and for >> the sake of a DB-neutral implementation we have kept the queries basic. So >> this means we handle some joins etc at application-level. This is why it >> has to be transactional. >> >> But, I was under the impression that the cache solves this issue >> altogether with the get() doing nothing @ Embedded Registry level. Isn't >> this the case or are you talking about first call slow-down? >> >> Thanks, >> Senaka. >> >> >> On Mon, Aug 18, 2014 at 6:36 AM, Subash Chaturanga <sub...@wso2.com> >> wrote: >> >>> Hi Senaka et al, >>> Is there any particular reason for doing $subject ? Because >>> transactional db connection is always heavy and many applications doing the >>> GET quite frequently. IMO we should not be doing a read in a transactional >>> manner. Pls correct me if I am missing something. >>> >>> I am referring EmbeddedRegitry#get. >>> >>> -- >>> Thanks >>> /subash >>> >>> *Subash Chaturanga* >>> Senior Software Engineer & Lead WSO2 Governance Registry >>> Platform TG; WSO2 Inc. http://wso2.com >>> Contact: >>> email: sub...@wso2.com >>> blog: http://subashsdm.blogspot.com/ >>> twitter: @subash89 >>> phone: +9477 2225922 >>> Lean . Enterprise . Middleware >>> >> >> >> >> -- >> >> >> *[image: http://wso2.com] <http://wso2.com> Senaka Fernando* >> Software Architect; WSO2 Inc.; http://wso2.com >> >> >> >> * Member; Apache Software Foundation; http://apache.org >> <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: +1 >> 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >> >> >> *M: +44 782 741 1966 <%2B44%20782%20741%201966> Linked-In: >> http://linkedin.com/in/senakafernando >> <http://linkedin.com/in/senakafernando>* >> Lean . Enterprise . Middleware >> > > > > -- > /sumedha > m: +94 773017743 > b : bit.ly/sumedha > -- *[image: http://wso2.com] <http://wso2.com> Senaka Fernando* Software Architect; WSO2 Inc.; http://wso2.com * Member; Apache Software Foundation; http://apache.org <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: +1 408 754 7388; ext: 51736*; *M: +44 782 741 1966 Linked-In: http://linkedin.com/in/senakafernando <http://linkedin.com/in/senakafernando>*Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev