use Perl

• Always use count(*) (Score:2)

  by djberg96 (2603)

  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.
  • Re: (Score:1)

    by jk2addict (4946)

    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
    • Re:Always use count(*) (Score:2)

      by djberg96 (2603) on 2006.10.02 14:17 (#50674) Journal

      Interesting, thanks for the link.

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

      Reply to This

      Parent