 |
 |
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