Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • With Oracle at least. It's a misconception that count(foo) is faster than count(*), in case that's the reason you were avoiding it.

    Mind you, I can speak for certain with MySQL, but it may be similar.

    • Actually, Jay Pipes of MySQL gave a talk this weekend about MySQL perf stuff. One of the slides was about not really using count at all if you don't have too, depending on things like MyISAM/InnoDB.

      http://jpipes.com/presentations/mysql_perf_tuning.pdf [jpipes.com]
      pg.16

      Offtopic, but he did a good job of presenting things that I wouldn't normally think about as just a DBIC->mysql user, like how the two engines deal with indexes across multiple keys, etc. Probably stuff any good MySQL dbadmin knows and I never think ab
      • Interesting, thanks for the link.

        That should have been "can't speak for certain", btw. :)