Hi Denny, The issue has been fixed now, please cvs update your code.
Let us know if you have further questions. Cheers, Junjun > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Chan, Denny > (NIH/NCI) [C] > Sent: Thursday, July 23, 2009 9:17 AM > To: Syed Haider > Cc: [email protected] > Subject: RE: [mart-dev] query performance > > Hi Syed, > > Did you have chance to look into this? > > Thanks, > Denny > > -----Original Message----- > From: Syed Haider [mailto:[email protected]] > Sent: Monday, July 13, 2009 6:16 PM > To: Chan, Denny (NIH/NCI) [C] > Cc: [email protected] > Subject: Re: [mart-dev] query performance > > Hi Denny, > > there is a statement for unique values for MySQL and PG. If, > for some reason its not doing what its intended to, let us > investigate and fix. > > thanks for reporting this, > Syed > > > Chan, Denny (NIH/NCI) [C] wrote: > > Hi, > > > > > > > > I was looking at the _toSQL method in the FilterList.pm > module. The > > routine removes duplicates values from the IN list for > oracle database. > > Why not for the others? > > > > > > > > I use postgresql database. The duplicates really slow down > the query > > performance. > > > > > > > > Thanks, > > > > Denny > > >
