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