Is this good option to use data caching for 8MB data (1 lakhs records, 5000 record increase every month) in MVC application ?

Question

0.00/5 (No votes)

See more:

Currently using Web API to access exchange data and there is an increase of 5000 records every month. Total size as of now is 8 MB. Someone suggested me to use data caching for this data. Please help me to identify, when to use data caching based on below parameters.

Data Volume
Monthly new addition of 5000 records
Highly in used

What I have tried:

What is recommended for data caching

Posted 12-Jan-19 9:52am

Navneet Kumar

Updated 12-Jan-19 23:45pm

Add a Solution

Comments

Dave Kreskowiak 12-Jan-19 16:00pm

Caching data and how much of it depends on the context the data is used and how often it is required.

You haven't said anything about what data you're talking about, how often it's used, if you're using all of the records in some processing or just a few of them, ...

Just throwing "caching" at data doesn't help you at all. It's the use of the data and the workload that justifies it.

Navneet Kumar 13-Jan-19 2:33am

This data is exchange rates, at a time, one exchange rate will be used for the transaction.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AnkushK1 · Answer 1 · 2019-01-12T23:45:00

I would not suggest you to go for direct in-memory caching since with growing cache, the performance of application will degrade.

However, you can consider using open source tools like Redis that allows you to cache data without causing any performance related issues and better management of cache data.