• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

cach?

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi!
I am spending some hours designing a cach for our database. But now I am in doubt.
Do we need a cach in our database?
What do you think? I guess not, since it has rarely been a topic in this discussion group.
On the other hand, the assignment says:'Note that the locking required is effectively a "write" lock only'. And it is fun to implement. But overdesigning is not rewarded I suppose.
/Hugo
 
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The only caching I have is on the client side. I needed a table model anyway to populate the JTable, so I'm using the table model as a place to store FieldInfo and DataInfo between searches. Of course, the cache will be out-of-date as soon as another client updates the database, so I need to re-read the database before doing any updates.
 
Ranch Hand
Posts: 560
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
No need to design cach. It is efficient to query the database when you need them.
 
Hugo van Elk
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Robin Underwood:
The only caching I have is on the client side.


I mean server side to avoid locking overhead an disk access. The serverside cache is not locked for non-destructive methods, for reading there is no locking overhead at all. That would be the benefit. But the assignment does not stress this point.
/Hugo.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'd avoid trying to implement any caching. no cache needed. I just wanted to spell out cache.
There is no requirements in the spec for it.
Mark
 
Catch Ernie! Catch the egg! And catch this tiny ad too:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic