Forums Register Login

Cached Data, Updatable ResultSets

+Pie Number of slices to send: Send
I have a concern over using Cached Data and/or Updatable ResultSet (which is a form a cached data I suppose).
How can you possbily ensure consistency on data using cached data and cached result sets with multiple users accessing and updating the database?
My approach has always been to get the data I need, and only what I need, modify it, update it, whatever, then be done with it until needed again. I then started looking into using cached data and updatable resultsets for performance issues, but the more I look into it, the more I don't understand how data can stay consitent and current with multiple users accessing the same data.
I realize there are isolation levels so I can lock tables etc, and I do use that but I only have tables locked for a split second at best when making a change or adding data. But if I lock a table then use cached data to manipulate, the table would be locked for a long period of time, would it not?
Anyone care to give me some advice/input on advantages to cached data as it seems to be the "to do" thing these days?
Thanks.
We've gotta get close enough to that helmet to pull the choke on it's engine and flood his mind! Or, we could just read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 902 times.
Similar Threads
Networking : RMI
Data fetch from multiple SQL tables
NX:Locking and synchronization
IS the locking mechanism in the EXAM CRAM2 book wrong
NX FileChannel & Thread Safety
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 01:23:26.