They stored data in the array and then did a bunch of queries against that array. Queries like "select * from foo where array contains value".

Shocker, that's slow.