Re: Trouble With Counting New Documents With Complex Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jeremy Peterson wrote:
 
> I haven't tested this code, but it should get you started.  I imagine that
> you have a lot of different days that you are trying to restrict in your
> query (This could be costing you a lot of time), so the first query removes
> all articles you don't want up front before doing your joins.  If you were
> using a database that allows subselects, you could have shortened this even
> more (Last I heard MYSQL doesn't support subselects).  Ultimatly you
> shorten the time the query executes because you are removing unnecessary
> computation with the joins.
> 
> I hope this helps you along your way.

	Thank you, I'll try to make something out of it
 and test it :8] Maybe I will even get an idea or two
 to improve it futher...

-- 
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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux