"Kim Steinhaug" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> After crawling through the MySql reference I finally found the function I
> was
> looking for, the sollution for combining theese two queries would be :
>
> SELECT count( * ) AS online_anonymous, sum( sign( uid ) ) A
After crawling through the MySql reference I finally found the function I
was
looking for, the sollution for combining theese two queries would be :
SELECT count( * ) AS online_anonymous, sum( sign( uid ) ) AS
online_members
FROM `database`
I also benchmarked this and the performance went j
And ofcourse, one part I didnt take into the equation,
one complex query doesnt always execute faster than
two fast queries.
So I might as well be sure that the environment is optimized
for the two queries im already having...
I still however would like to know if its possible to join the
two int