Hi gurus, we got a table (user_table)holding user info and the number of records in the table were getting bigger and bigger. So we've separated it to two tables( user_table_0, user_table_1) because of the performance. ( Of course, both tables has the exactly same schema. )
And now we want to make a CMP that treats both tables as a one table seemlessly. Is it possible to make it with only one CMP ? or Do we have to make two CMPs ? I think if the EJB-QL or JBOSS-QL(?) can take a table name dynamically, we can make it.. Thanks in advance. ps) Oracle has the functionality that represents two tables as a one table, but no luck...we use MySQL. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3860363#3860363 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3860363 ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user