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.
On Tue, Jul 23, 2002 at 04:11:14PM -0700, lcrocker@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
wikitech-l@lists.wikimedia.org