Well, that's pretty simple table and I'm sure you have index on id column, so 200 queries per second shouldn't be a problem for mysql if you just selecting records by id. Anyway as you already saw perl requires too much memory to store your data, so it seems you're tied with database solution.