Re: Trouble With Counting New Documents With Complex Query
| From: | Adam i Agnieszka Gasiorowski FNORD | Date: | Fri, 02 Jan 2004 20:50:36 +0000 |
| Subject: | Re: Trouble With Counting New Documents With Complex Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32249@lists.php.net to get a copy of this message | ||
Jeremy Peterson wrote:
> If you are concerned with speed, consider multiple queries. Joins cause
> most delays. Give that a shot.
What do you mean? Sorry, please explain
futher, I don't know what you have in mind...
I have to do some of those joins, because of
the relationships between tables - I don't
want to count invisible articles, so I have
to JOIN on x_instance table to get to know
if they are visible at all in any of the
subsections in the section tree. How would
you solve this dilemma? Thank you for your
time.
(sorry if my English is sometimes hard to understand)
--
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
Attachment: [application/x-pkcs7-signature] S/MIME Cryptographic Signature smime.p7s