hi!

i have a mysql5 db, with hibernate 3, frame generated by myeclipse.

for example i have 1000 clients, with polling every 2sec for server.
server make a query, and execute it. (2 table joined). Probably, this will overload the database. ( 500 query / sec ) I would like to use 2nd level cache. Later it will be clustered, so the best for me, is the threecache implementation. The database will be modified by hibernate only (mostly), but in cluster.

my questions is:
1., I need something like keep these 2 tables all entities in memory, only write changes to database, but for query use the cache. (and sync cache through cluster members). (these 2 tables have about 10k records constantly)
this is what 2nd level cache for?

this will decrease the database server load ?


2., in a clustered environment, data changing in one member, how will visible by the others? (using cluster able second cache)
read the docs, it seems so easy... it is?

thx
regards,
Szabi