Our team is building an RCP application using PostgreSQL for DB. We are evaluating the usage of Hibernate. Our project has the following constraints :
1) The project is a small extract-and-run-in-any-system type RCP application which is mostly used by non-technical users with a minimum setup needed. The application should have a low memory footprint under available memory (around 2GB of RAM).
2) The DB is read-only and the application reads millions of rows. Hence, currently there is a visible sluggishness while start-up and DB reading.
3) The application on a whole is portable - able to be carried in a pen drive.
4) The application has a lot of relation model to object model mapping currently done through stored scripts.
Does hibernate fit the bill? What are its impact on memory and portability?
Thanks in advance....