pkundurthy/uwpyKepler — comment on commit b75d844436793910cf41461671fa5f4bb5c04fff
File:  line 0
By acbecker:

I would use:

mysql> select count(*) from source where (KEPLERID = 7630565 and LCFLAG = 0);

/\

On 11/7/11 3:10 PM, johnm26 wrote:
> new:
> select KEPLERID from source where (KEPLERID = %s and LCFLAG = 0) LIMIT 1 % (KeplerID)
>
> old:
> select DISTINCT KEPLERID from source where (KEPLERID = %s and LCFLAG = 0) % (KeplerID)
>
> We thought it would be faster to query for one data point since that's all we need to determine whether there's data for a given cadence type.
>
> ---
> Reply to this email directly or view it on GitHub:
> https://github.com/pkundurthy/uwpyKepler/commit/b75d844436793910cf41461671fa5f4bb5c04fff#commitcomment-701277