Hi,

I am building a database for posting forum topics that relate to pages of a base document. It is expected that there will be lots of new posts, and I'm trying to think of creative ways to reduce contention.

So I have a Post bean. And using MySQL/ISAM. I wonder if I can/should somehow split the bean, which has a pageIndex property across K tables, since all my queries are by page index of the base document, and I can ensure that the entity beans are put in the table appropriate for that PageIndex mod K.

The question is (1) will this improve the performance with heavy read/writes, and (2) is there a way to map one bean to multiple tables like this?

Andy