How to do the capacity planning of the cache - for e.g. how much RAM to allocate for ehCache, memcache or dynacache? Is there any industry standard formula?
For e.g. I have about 60,000 Records in the database. This is the company data - which contains company name, description and company code. I want to implement a typeahed feature using jQuery and want to store this company name details in the cache.
What would be ideal cache size? I know that cache size is limited to the amount of free memory available but interested to know a specific way? or is t a trial and error where you start with some size and test, plot a graph and keep adjusting the cache size.
Update
Company Id - CHAR(9)
Company Name - VARCHAR2 (250 CHAR)
Company Desc - NVARCHAR2(1000 CHAR)