In memory database or Caching solution

[al0]

And why not simply HashMap with city as key?

Hello we developing an application, using Spring ibatis connect to mysql.
The application hava a function which judgement ip address from city, to active different event.

in asp.net it's easy, cache dataset in memory, using query string query "city" rows.but in java we engage performance problem. Is there any object like dataset in .net, to storage data in memeory and be queried, and using JCS cache it. Or other way to complete this funciton.

Any suggestions will be very helpful

Thanks

[praba_tuty]

CSQL is open source caching product which can cache tables from MySQL, Postgres and Oracle databases. It provides 100X more throughput for data access with no or minimal application code changes.
http://www.csqldb.com