Re: Trouble With Counting New Documents With Complex Query

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: [application/x-pkcs7-signature] S/MIME Cryptographic Signature smime.p7s