This is the second of four articles about Database Management Systems’ (DBMS) performance. The first of these four articles presented an overview and some installation tips. The article you are now reading talks about building the database’s tables and indexes. Parts three and four get into the meat of accessing the database, with non-SQL tips in the third article and SQL tips in the fourth.
Website Performance: Taxonomy of Tips introduced a classification scheme to help us organize the many performance tips found on the Internet. Database Management Systems fall into category #3.2 (the-server-side-script-accesses-a-service).
Although this article is based on MySql experience, the concepts apply to other DBMS’s as well. Read more…
