I m building a Route Planner Webapp using Spring/Hibernate/Tomcat and a mysql database, I have a database containing read only data, such as Bus Stop Coordinates, Bus times which is never updated. I m trying to make the app run faster, each time the application is run it will preform approx 1000 reads to the database to calculate a route.
I have setup a Ehcache which greatly improves the read from database times. I m now setting terracotta + Ehcache distributed caching to share the cache with multiple Tomcat JVMs. This seems a bit complicated. I ve tried memcached but it was not performing as fast as ehcache.
我很想知道,MongoDb或Redis是否更适合。 我没有节奏的经验,但我很想知道是否有任何想法。 所需要的是,能够迅速进入读数据库。