On Tue, Jul 23, 2002 at 04:11:14PM -0700, lcrocker(a)nupedia.com wrote:
As Neil suggested, couldn't these checks be
done in just one big
query rather than a lot of separate ones? ie, something like:
SELECT cur_title
FROM cur
WHERE cur_title
IN
('Scientist','Research','Astronomy','Astrophysics',[...])
or would that just get more complicated?
It would actually be more like:
SELECT cur_id,cur_namespace,cur_title FROM cur WHERE
(cur_namespace=0 AND cur_title='Scientist') OR
(cur_namespace=0 AND cur_title='Research') OR
(cur_namespace=1 AND cur_title='Scientist')
etc. I'm not sure how well that would optimize.
You can get all the links with one simple SQL statement from the table
'links' except when doing a preview.
-- Jan Hidders