OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Trouble With Counting New Documents With Complex Query

From: Adam i Agnieszka Gasiorowski FNORD (agquarxvenus.ci.uw.edu.pl)
Date: Sun Jan 04 2004 - 03:15:57 CST

Bob Terrell wrote:
 
> So there you go. Give it a shot and see if it runs any faster. If you need the time, replace that first test in the WHERE clause with the one mentioned above. If this is run often (or if it just takes a _really_ long time), put an index on the date field, if one isn't there already. Your query as it stands has to read the entire table just for the date field.

        Ah, now it striked me, that I should add
 to this sum of WIKI articles instantiated in
 "2" OR "5". Will do it with a second query or
 use one of the functions written by my comrade
 emes, I will have to look into the code to
 check if I have to write my own.

        Thanks again!

--
Seks, seksić, seksolatki... news:pl.soc.seks.moderowana
http://hyperreal.info { iWanToDie } WiNoNa ) (
http://szatanowskie-ladacznice.0-700.pl foReVeR( * )
Poznaj jej zwiewne kształty... http://www.opera.com 007

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql