MongoDb vs Ehcache caching advise for speeding up read only mysql Database

Posted by paddydub on Stack Overflow See other posts from Stack Overflow or by paddydub
Published on 2010-05-19T01:53:35Z Indexed on 2010/05/19 2:00 UTC
Read the original article Hit count: 613

Filed under:

mongodb

|

nosql

|

ehcache

|

hibernate

|

mysql

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.

I'm wondering if a MongoDb would be better suited. I have no experience with nosql but I would appreciate if anyone has any ideas. All i need is quick access to the read only database.

© Stack Overflow or respective owner

Related posts about mongodb

MongoDB usage best practices

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
The project I'm working on uses MongoDB for some stuff so I'm creating some documents to help developers speedup the learning curve and also avoid mistakes and help them write clean & reliable code. This is my first version of it, so I'm pretty sure I will be adding more stuff to it, so stay tuned… >>> More
Errors trying to run MongoDB

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I'm running Ubuntu Server 12.04 (32 bit) on an old (1998) computer. Everything's working fine until I try and start MongoDB. somekittens@DLserver01:~$ mongo MongoDB shell version: 2.2.2 connecting to: test Sun Dec 16 22:47:50 Error: couldn't connect to server 127.0.0.1:27017 src/mongo/shell/mongo… >>> More
push new value to mongodb inner array - mongodb/php

as seen on Stack Overflow - Search for 'Stack Overflow'
hi i have this document in mongo: { "_id": ObjectId("4d0b9c7a8b012fe287547157"), "done_by": ["1"] } and i want to add another value to "done_by" field, so my expected document will be:: { "_id": ObjectId("4d0b9c7a8b012fe287547157"), "done_by": ["1","2","3"] } i try this: $conn… >>> More
Write-only collections in MongoDB

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently using MongoDB to record application logs, and while I'm quite happy with both the performance and with being able to dump arbitrary structured data into log records, I'm troubled by the mutability of log records once stored. In a traditional database, I would structure the grants for… >>> More
How to install mongoDB on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I am trying to test out mongoDB and see if it is anything for me. I downloaded the 32bit windows version, but have no idea on how to continue from now on. I normally use the WAMP services for developing on my local computer. Can i run mongoDB on Wamp? However, what's the best (easiest!) way… >>> More

Related posts about nosql

???: Oracle NoSQL Database??

as seen on Oracle Blogs - Search for 'Oracle Blogs'
?????????Oracle?????Oracle NoSQL Database,?????NoSQL Database ??????????Oracle NoSQL Database??2???,Community Edition ?Enterprise Edition?????????NoSQL Database 11g R2 (11gR2.1.2.123). ?????????????????: Oracle NoSQL Database OTN portal (includes download facility) Oracle NoSQL Database… >>> More
Free NOSQL database for use with C# client [closed]

as seen on Programmers - Search for 'Programmers'
I've never used NOSQL databases before, but so far it seems like the best data storage solution for my project. I am going to implement a datamining application. The data I would like to mine is thousands of documents which cannot be imported into datamining applications. To make to import easier… >>> More
Big Data – Buzz Words: What is NoSQL – Day 5 of 21

as seen on SQL Authority - Search for 'SQL Authority'
In yesterday’s blog post we explored the basic architecture of Big Data . In this article we will take a quick look at one of the four most important buzz words which goes around Big Data – NoSQL. What is NoSQL? NoSQL stands for Not Relational SQL or Not Only SQL. Lots of people think… >>> More
Oracle Big Data Learning Library - Click on LEARN BY PRODUCT to Open Page

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Big Data Learning Library... Learn about Oracle Big Data, Data Science, Learning Analytics, Oracle NoSQL Database, and more! … >>> More
NoSQL with RavenDB and ASP.NET MVC - Part 1

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
A while back, I have blogged NoSQL with MongoDB, NoRM and ASP.NET MVC Part 1 and Part 2 on how to use MongoDB with an ASP.NET MVC application. The NoSQL movement is getting big attention and RavenDB is the latest addition to the NoSQL and document database world. RavenDB is an Open Source (with… >>> More