This is for those who work with MySQL.
The article at the end of this entry talks about how the storage engines(MyISAM, InnoDB, etc.) works. Since I use the default storage engine (MyISAM), it’s helpful to know about the difference between static rows and dynamic rows.
I’m going to review the database structure I’ve come up with for a project at work and see if I can make changes to make the rows static.
MySQL Storage Engine Architecture, Part 2 – An In-Depth Look
Wishing you lower seektimes.