java - Can guava cache help me with storing results of approx. 100 records? -
i've been searching solution cache following:
1) have small mysql table (~100 rows)
2) there 2 different select queries hitting table 2 different servlets
(i need random order of items every time order rand
)
select sku, category, title, item_image_url_small itemdata display = 'on' , category = 'table' , customer = ? , parameter = ? order rand() limit 2 select sku, category, title, manufacturer, price, list_price, star_rating, model, item_image_url_small, item_image_url_medium itemdata display = 'on' , available = 'yes' , category not in ('table', 'case', 'chair') order rand() limit 3
3) table getting updated every 8 hours
4) majority of fields varchar
type
i'd cache results of both queries. guava right solution , if so, there example check has caching multiple columns?
thanks!
Comments
Post a Comment