We have around 100 GB of data from different entities.
There are some dimension, some fact and some transaction entities.
Transaction items are in the range of 50 millions of rows.
All this data is stored in blob storage with one csv file for each entity.
There will be a copy in In-Role Cache for quick access.
In addition transactions happening are required to be processed using LINQ joins with some other entities and update, insert or delete items on entities stored on cache as well as the data on Blob Storage.
Is it a good idea to store each entity as a list (which is one object per entity) on the cache?
or store the each item(row) in the list(entity) separately on the cache?
what is the usual practice in this kind of cache scenarios?
Storage Strategy on Azure In-Role Cache
63 Views Asked by Srinivas At
0
There are 0 best solutions below
Related Questions in LINQ
- How to filter properties of derived classes in a DbContext with dynamic LINQ
- Query (or LINQ in Entity Framework) for getting user's rank
- How to return Inserted Updated Id in a Merge query
- Equivalent of LISTAGG in LINQ doesn't work
- Getting attribute from xml and printing it error
- Linq Grouping and workaround data entry errors in groups
- 'Unable to cast the type 'System.Guid' to type 'System.Object'. LINQ to Entities only supports casting EDM primitive or enumeration types.'
- linq issue accessing deep xml data
- OrderBy with lambda?
- Evaluating logical expressions recognized by ANTLR using the System.Linq.Expressions namespace
- Implementing List<T>, why wont it cast back to MyList after LINQ ? (Unable to cast object of type 'WhereListIterator`1)
- Linq GroupBy and Filter
- LINQ group by date and time
- How do I achieve client-side evaluation in LINQ?
- How do I create a Linq query that will return multiple complex properties in a sub property of a table?
Related Questions in CACHING
- Using Puppeteer to scrape a public API only when the data changes
- Caching private wordpress rest endpoints
- Cloudflare not respecting Cache-Control
- Unexpected Recursive Call
- Cannot serialize (Spring Boot)
- Nginx only caches file endpoints
- The Selenium application properties folder holds two environment options. After running a test the environment setting changes to a previous setting
- Launch jobs in cache in a loop in bash script
- Multiple async request do not store anything to cache
- Dev tool for Next.js cache on the client?
- Creating a letter in the terminal by entering
- Laravel: check if cache has key with thag
- The retrieval time for the Apache Ignite cache is too long
- How to run gradle with caches files
- Docker Run cache mount does not cache apt-get dependencies
Related Questions in AZURE
- How to update to the latest external Git in Azure Web App?
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Inject AsyncCollector into a service
- mutual tls authentication between app service and function app
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Application settings for production deployment slot in Azure App Services
- Encountered an error (ServiceUnavailable) from host runtime on Azure Function App
- Implementing Incremental consent when using both application and delegated permissions
- Invalid format for email address in WordPress on Azure app service
- Producer Batching Service Bus Vs Kafka
- Integrating Angular External IP with ClusterIP of .NET microservices on AKS
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Azure Batch for Excel VBA
- How to authenticate only Local and Guest users in Azure AD B2C and add custom claims in token?
- Azure Scale Sets and Parallel Jobs
Related Questions in AZURE-CACHING
- How can I understand these error logs? Does it mean that Django backend can't connect to redis?
- Can I configure 'Cache' task in Azure Pipelines to only restore the cache and not the save the cache?
- Caching App Configuration values in Azure Cache for Redis
- APIM - cache request with authorization header for all users (not per user)
- I have a azure frontdoor with caching enabled on route by deafult the caching is 1 to 3 days how to override it using rules what condition to use
- How do I specify a policy so that Azure API Management creates a different response cache for each combination of query parameters?
- Azure DevOps, ENOENT issue with NPM Caching
- Can I restrict Azure API Management cache storage by response content?
- How can I deny all the public access to my azure cache for redis?
- Azure SQL VM - Premium Storage Caching or P50 or more disks?
- tar: could not chdir to 'D:\a\1\docker'
- 'vary' in APIM caching policies
- Caching node_modules in Azure Pipelines takes longer than installing them
- Running SQL query against Azure redis cache
- Environment.SetEnvironmentVariable in Azure Function
Related Questions in AZURE-IN-ROLE-CACHE
- Azure In-Role Cache Retirement
- Serializing CloudBlockBlob for Caching
- Implementing In-Role caching Co-located and Dedicated together
- In-role, co-located caching & CacheService.exe
- Windows Azure In-Role Caching not working after SDK 2.5 Upgrade
- Windows Azure In-Role Caching Exception issue
- Cache Host config in Azure In-Role caching
- Local Cache and immutable objects - zero timeout
- Caching large objects - LocalCache performance
- Multiple DataCacheClients - Strange configuration behaviour
- Performance difference between Azure Redis cache and In-role cache for outputcaching
- Storage Strategy on Azure In-Role Cache
- Azure in Role Cache and Windows Server AppFabric Cache in same solution
- Azure In Role Caching Doesn't start on server with "Not running in a hosted service or the Development Fabric."
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?