• Bye@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    8 months ago

    How come people use sql instead of just using text files? I just use text files for everything

  • Anna@lemmy.ml
    link
    fedilink
    arrow-up
    0
    ·
    8 months ago

    This is fake the pid of the younger guy is smaller than that of grandpa

    • breadsmasher@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      8 months ago

      I don’t think its mysql specifically, but for some reason the worst systems I have used, all have mysql/mariadb as a database.

      It seems shitty applications gravitate to mysql, use it poorly, then bring a bad name to mysql.

      But given all my years of experience with it, MSSQL > Posgresql > Mysql > Oracle

      • vapeloki@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        8 months ago

        I was a DBA for over 10 years. Postgresql is superior to mssql in most ways. Especially replication.

        But that does not mean that mssql is bad. MySQL is, oracle is.

    • marcos@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      8 months ago

      Usually DBMSs have some small capacity to handle requests in parallel so everything slows down, but work is still getting done.

  • RagingToad@feddit.nl
    link
    fedilink
    arrow-up
    0
    ·
    8 months ago

    Allergic to Indices? If your database is slow just add more Indices until you have one on every column of every table! :-)