Hi Thank you for reading my post I should design and implement an application which is going to run on tomcat 5.5 and Database can be one of derby ,sqlServer , Mysql. Problem is that this application should be able to have about 15 -20Transaction in 1 second .They have no extra power servers , just an ordinary hosting plan. my question is : which of this database is better to choose ? i thought that derby could be better because it can be embeded into my application . can derby carry out 15-20 transacion in 1 secod ? is it feasible with using DAO pattern and plain JDBC ,or it need some other requirement ? [ October 30, 2005: Message edited by: Bear Bibeault ]
Hi Thank you for reply. There are not sophisticated operation per transaction 3 insert + 3 update . it is a web application at most 20 connection at the same time. Generally it is going to be an ADs manager , provider system A system that manage and handle hist for diffrent Ads (banners).