Nice! Can you try a full table scan, just to see the timing?
Something like
SELECT deepSourceId, u_apFluxSigma FROM LSST.Object
WHERE u_apFluxSigma between 0.01 and 0.02
would do it
Jacek
On 05/07/2015 05:27 AM, Fabrice Jammes wrote:
> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host
> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId,
> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 2381971682496089;"
> +------------------+----------------------+
> | deepSourceId | u_apFluxSigma |
> +------------------+----------------------+
> | 2381971682496089 | 2.31359138208982e-30 |
> +------------------+----------------------+
>
> real 1m35.509s
> user 0m0.007s
> sys 0m0.015s
> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host
> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId,
> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 2381971682496090;"
> +------------------+----------------------+
> | deepSourceId | u_apFluxSigma |
> +------------------+----------------------+
> | 2381971682496090 | 2.35166823179121e-30 |
> +------------------+----------------------+
>
> real 0m0.112s
> user 0m0.007s
> sys 0m0.015s
> fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host
> ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId,
> u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 4210970620594023;"
> +------------------+----------------------+
> | deepSourceId | u_apFluxSigma |
> +------------------+----------------------+
> | 4210970620594023 | 3.36652987269481e-30 |
> +------------------+----------------------+
>
> real 0m5.187s
> user 0m0.007s
> sys 0m0.017s
>
> ########################################################################
> Use REPLY-ALL to reply to list
>
> To unsubscribe from the QSERV-L list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1
########################################################################
Use REPLY-ALL to reply to list
To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1
|