I'm running a DB query on a database of firewall log entries (right now around 700k rows). What I want to do is pull out some common entries, as well as the number of times that they occur in the table.
Right now, I'm doing a query like: select source,destination,service,count(*) FROM logs WHERE action='$type' GROUP BY source,destination,service ORDER BY count DESC LIMIT $num; This is a little more advanced than I'm used to doing, so I'm wondering if that query is the best way to get that data, or if there's another way of doing it. Thanks, Wade -- Do your part in the fight against injustice. Free Dmitry Sklyarov! http://www.freesklyarov.org/ Fight the DMCA! http://www.anti-dmca.org/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
