Hello we have an application running, using Spring and database is SQLServer.
The application is giving us problems wrt to performance.
We are thinking of using some caching mechanism in our application.
Any thoughts which is better In memory databases like HSQLDB or H2 or
java caching solutions like ehcache or JCS.
We want to cache lots of data in memory/disk that is primarily queried again and again from database and run our application validations against that data. Basically mostly reads very little writes.
Any suggestions, tips will be very helpful