on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote: > Tell me if you need any additional information. > Thank you for all your help.
Some additional information would help, yes. What exactly are the sections, for example? Do you need to know the number of new _articles_ total, the new of new articles per section, or do sections also count as documents somehow? Can an article really belong to more than one section (or a section to more than one article)? I wasn't sure if "section" is an article section (page 1, page 2, etc), or if "section" is the category the article belongs to. I visited the site, but I don't speak the language, so I wasn't quite sure what was going on. Your query may be running slowly due to more than one factor. Although I see a couple of ways to help in just the where clause, dropping a table join or two would also help if it can be done. -- Bob IQ2GI5SCP2 Things You Don't Hear Every Day, #'s 16 and 17: A professor: "It's all right if you come to class high." A(nother) professor: "I think base 16 is cool." -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
