Two days ago I ran into an issue with ActiveScaffold (AS) and Kotoba whereby performance was degraded as the number of words in the database increased. At first I thought there was an issue with AS itself in the way in which it handled associations. However, I had overlooked a table index on the child entity’s parent id. Once the index was included in the schema things took off.
Remember, kids. Indexes are key.