FYI, I managed to run 3 different queries (on Source) using
the new shared scan code:
select sourceId, ra, decl from Source where xFlux between 0.02702 AND 0.029
14 min 28 sec
---
SELECT ROUND(radius_SG, 0) AS rr, COUNT(*) AS theCount FROM Source
GROUP BY rr ORDER BY theCount
14 min 26 sec
----
SELECT
ROUND(ra+raErrForDetection+raErrForWcs, 0) AS ra,
ROUND(decl+declErrForDetection+declErrForWcs, 0) AS decl,
ROUND(xFlux+xFluxErr),
scisql_fluxToAbMag(xFlux) as xMag,
scisql_fluxToAbMag(yFlux) as yMag
FROM Source
WHERE
scisql_fluxToAbMag(xFlux) > scisql_fluxToAbMag(yFlux)
AND raErrForDetection+raErrForWcs < 0.0001
limit 3
14 min 35 sec
When I run all 30 queries similar to these 3 above, a few of
them failed, the rest finished in 25 min 04 sec (and I don't
have time to debug this...)
So, Daniel's 3 min for 1 query and 5 min 27 sec for 30
adn my numbers are comparable
(3m : 5m27s = 6.06%,
14m6s:25m30s = 5.71%)
Jacek
Jacek
########################################################################
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
|