use Perl

• heh (Score:1)

  by Alias (5735)

  > There are legitimate uses for MyISAM, but not many.
  
  Like maybe a counter script, or some sort of simple log table, which about the most sophisticated things I've ever used it for.
  • Re: (Score:1)

    by Abigail (26)

    No, not even a counter script. Remember, MyISAM doesn't give you transactions, and for a counter script, you generally want to do:

        update counter set value = value + 1
        select value from counter

    and you want to do that atomically.

    Without transactions, why even bother having a database server?
    • Re:heh (Counter script) (Score:1)

      by Corion (7288) <corionNO@SPAMcpan.org> on 2006.12.12 10:03 (#52230) Homepage Journal

      Of course, for a counter you want to do

      insert ip into counter

      :-), and for querying it then

      select count(*) from counter

      ... Now, if that's actually better than just an atomic append of a(ny) line to a text file remains to be discussed ...

      Reply to This

      Parent

      • Re: (Score:1)

        by Abigail (26)

        Yes, but you still want to wrap those statements into a single transaction.