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
> 

Reply via email to