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

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

Enable autocomplete or intellisense in Atom editor for PHP -