in reply to Musings about a database ecology

I'll second what Mutant said: if you are running into data scalability issues at 9000 items then something is wrong in your database design. Perhaps some queries are slow. Perhaps you're manually fetching and refetching in an unfortunate way. Either way the odds are very good that an appropriate index or 3 will solve your problem for a bit with no application changes.