Keywords: DataAccWG
Sorry, sent to the wrong mailing list the first time...
Jacek
-------- Original Message --------
Subject: Re: [lsst-slac] Cone-magnitude-color search
Date: Wed, 5 Jul 2006 14:18:48 -0700 (PDT)
From: Kem Cook <[EMAIL PROTECTED]>
Reply-To: lsst-llnl-slac collab <[EMAIL PROTECTED]>
To: lsst-llnl-slac collab <[EMAIL PROTECTED]>
CC: lsst-llnl-slac collab <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Most school kids would want time, mag, magerr, colors, colorserrs for each
objID returned. Professional astronomers would probably want everything.
Kem
Keywords: DataAccWG
Hi Kem and Kirk,
Now that I started to assume we have memory for caching indexes,
I need to know whether selecting everything from Object table
for the "Cone-magnitude-color search"
SELECT *
FROM Object
WHERE ra BETWEEN <Ra1> AND <Ra2>
AND decl BETWEEN <Decl1> AND <Decl2>
AND zMag BETWEEN <z1> AND <z2>
AND gMag-rMag BETWEEN <gr1> AND <gr2>
AND iMag-zMag BETWEEN <iz1> AND <iz2>
is realistic. The reason I am asking is that if user wanted
objectId, ra, dec, plus all colors plus all magnitudes instead
of "everything", we could do this query without fetching
data rows. The "select *" in this query alone is driving number
of disks up by 23% (assuming 300 low volume queries per
10 high volume...).
thanks,
Jacek
_______________________________________________
lsst-slac mailing list
[EMAIL PROTECTED]
http://www.lsstmail.org/mailman/listinfo/lsst-slac
_______________________________________________
lsst-slac mailing list
[EMAIL PROTECTED]
http://www.lsstmail.org/mailman/listinfo/lsst-slac
_______________________________________________
LSST-data mailing list
[email protected]
http://www.lsstmail.org/mailman/listinfo/lsst-data
