Hi, I'm currently developing an application where many users store a lot of data in a MySQL database. This data needs to be queried quickly and often.
The problem is that the queries are already becoming slow even though we are expecting the number of users to increase tenfold. I'm considering 2 solutions to this problem: 1) Give each user his own MySQL database. Since the data for each user is unrelated, this is a good possibility, but I'm wondering how JBoss will respond to 1000 or more datasources. Will this cause problems? 2) Put the data for each user in separate tables.The MySQL documentation says that this will slow things down somewhat, but I think it will still be an improvement compared to putting everything in a few huge tables. Does anyone have any experience with these issues? Thanks in advance for your help. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3891423#3891423 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3891423 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
