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.
2 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! ;)