Re: What is a good benchmark?

2003-07-23 Thread Andrew Edwards
Is it me or do these dual athlons seem rather responsive! I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. - Original Message - From: "Christopher Knight" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]>

Select leaf nodes from tree

2003-03-14 Thread Andrew Edwards \(Olympic Shaver Centre\)
Hi, Given a simple tree structure represented in a table shown below: group_id: int parent_group_id: int description: varchar I am trying to select all rows from a table where the group_id does not appear elsewhere as a parent_group_id, hence selecting only the leaf nodes. I have wrestled with t