A new record | Rickard Andersson

A new record

As software applications that use SQL databases grow in functionality, so do the number of tables they use in the database. Not necessarily because they store more data but because they store more kinds of data. I believe PunBB, at least at the time I was working on it, had 17 tables. Microsoft’s App-V uses 46 tables. Ladok, the national system used for documentation of academic information at higher education institutions in Sweden, has 337 tables. But today, I almost fell out of my chair when I opened the database for CA Service Desk Manager, the service desk application we use in university IT. It has 2865 tables and 1388 views! Somebody likes to normalize their data.

12 comments

  1. Posted July 16, 2010 at 16:03 | Permalink

    What? 2865 tables? So many tables means many subs-systems that I can’t imagine… :)

  2. Stuart
    Posted July 30, 2010 at 21:59 | Permalink

    I’d say look at it’s efficiency. Perhaps it’s a table #1 (firstname), table #2 (lastname) kinda deal! ;)

  3. Posted May 31, 2011 at 22:40 | Permalink

    Hey Rickard! I found your website while troubleshooting a Mac server video issue (oddly enough) and began reading your blog. Looks like you stopped writing here a year ago. Kids will do that to you. I hope that the baby and the wife are doing well. Would love to see more posts sometime.

  4. Posted May 31, 2011 at 23:16 | Permalink

    Kids will indeed do that to you :) Apart from having a son, I really don’t have an excuse for not writing anything. Your comment is duly noted.

  5. Posted August 15, 2015 at 23:05 | Permalink

    Hi,

    I did a search on your name as it appears at the bottom of the CHORDIE page and was wondering if that’s you?

    If so, I would like to express my appreciation for giving this ol’ fart a place to hang out with other guitarists. It’s really very kind of you!

    If I’m mistaken, please excuse me. I have no earthly idea of what you’re writing about up there.

    All the best!

    Bill (“Strummerboy Bill” on CHORDIE)

  6. Posted March 16, 2019 at 00:14 | Permalink

    If some one needs to be updated with latest technologies therefore he must be pay a visit this web page
    and be up to date daily.

  7. Posted April 10, 2019 at 13:27 | Permalink

    I visit day-to-day some web sites and information sites to read articles, however this blog presents feature
    based articles.

  8. Posted April 29, 2019 at 10:07 | Permalink

    Enviei um e-mail para Facebook há quase um mês.

  9. Posted May 5, 2019 at 18:11 | Permalink

    I think everything posted was actually very reasonable.

    However, think about this, suppose you typed a catchier title?

    I mean, I don’t want to tell you how to run your website, however what if you
    added something that grabbed folk’s attention? I mean A
    new record | Rickard Andersson is kinda boring. You should peek
    at Yahoo’s home page and see how they create post titles
    to get people to click. You might try adding a video or a picture or two to grab
    people interested about what you’ve got to say. In my opinion,
    it would make your website a little bit more interesting.

  10. Posted May 16, 2019 at 19:23 | Permalink

    Magnificent site. Lots of useful information here.

    I’m sending it to some buddies ans also sharing in delicious.
    And naturally, thank you to your sweat!

  11. Posted May 17, 2019 at 21:53 | Permalink

    Real clear website, appreciate it for this post.

  12. Posted May 23, 2019 at 14:54 | Permalink

    Its fantastic as your other posts :D, regards for putting
    up.

Post a Comment

Comments are moderated. Your email is never published nor shared.