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 >
