June 26th, 2005

belize

linear search

A linear search of my entire journal text isn't too slow with InnoDB. In fact it's pretty damn fast.

Props to InnoDB and how our indexes are setup to cluster all rows based on primary key of form (journalid, jitemid)... so an entire journal is next to each other in the b-trees/disk.

People/things I've mentioned a lot:

Collapse )