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.
8 comments
What? 2865 tables? So many tables means many subs-systems that I can’t imagine… :)
I’d say look at it’s efficiency. Perhaps it’s a table #1 (firstname), table #2 (lastname) kinda deal! ;)
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.
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.
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)
Wonderful goods from you, man. I’ve understand your stuff previous to and you’re
just too excellent. I really like what you’ve acquired here, certainly
like what you’re saying and the way in which
you say it. You make it entertaining and you still care for to keep it smart.
I can not wait to read far more from you. This is
actually a tremendous site.
Der Artikel ist wirklich toll. Das Thema hat mich schon lange interessiert und ich konnte hier noch einiges
weiterführendes finden. Ich freue mich, weitere Artikel zu lesen. Danke und
Grüße aus Heidelberg Marco Feindler
Piękny artykuł, w sumie masz racje, jednak w niektórych
aspektach bym polemizowała. Z pewnością ten blog zasługuje na szacunek.
Myślę, że tu jeszcze wpadnę.