SmartGwtEE Performance

[liudi]

Hi Iso,

The data connection tools of SmartGwtEE are just great, i m currently using pure SQL data source.

As most of the relational data model frameworks, like Hibernate or iBatis, they are quite mature and comprehensive, and the performance of those frameworks has been tested in live use cases. I would be quite confident to use Java + MYSQL + iBatis + Tomcat for a web application to handle 2 million transactions with large amount of concurrent database/server interactions.

As i m about to build our project using SmartGwt Pro, and i chose to use pure SQL datasource to improve the query efficiency, so i got some questions here:

1. Can i use SQL Datasource to replace iBatis, will there be any impact? In other words, can i get rid of the ORM framework in an enterprise web application?

2. Can SmartGwt SQL Datasource handle tremendous amount of SQL? say 2 million transactions per day?

Thanks!

[Isomorphic]

Yes, it definitely makes sense to replace iBatis with the more powerful SQLDataSource, which also allows you to introduce Java objects to represent your records, when it's convenient.

By not assuming that you will write a Java class to represent your data, the SQLDataSource is generally more efficient that either Hibernate or iBatis.

[ledais]

thanks Iso, that's really a good news for me because i've found SQL datasource is much easier than Hibernate or iBatis during development, i'll be sticking to it!