 |
 |
Fabrice, Changing the selection criteria only changes how many rows will match and will be returned. We are still touching every single row, every single chunk. So changing the flux region does not help. What could help is introducing a bounding box, so that we are selecting from a subset of the chunks. Jacek On 05/07/2015 09:53 AM, Fabrice Jammes wrote: > Hi Jacek, > > The query you propose fails, I retried with smaller window: > time mysql --host ccqserv100 --port 4040 --user qsmaster -e "SELECT > deepSourceId, u_apFluxSigma FROM LSST.Object WHERE u_apFluxSigma between > 0.01 and 0.011" > > but I still have an error, see the czar log extract below: > > 0507 18:44:50.574 [0x7f439ca25700] INFO root > (build/ccontrol/MergingRequester.cc:230) - setError > 0507 18:44:50.575 [0x7f439ca25700] INFO root > (build/ccontrol/MergingRequester.cc:231) - setError -1 Request failed > 0507 18:44:50.575 [0x7f439ca25700] ERROR root > (build/ccontrol/MergingRequester.cc:168) - Error receiving result. > 0507 18:44:50.575 [0x7f439ca25700] DEBUG root > (build/qdisp/QueryRequest.cc:247) - Error finish > > Cheers, > > On 05/07/2015 05:35 PM, Jacek Becla wrote: >> 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