Page 1 of 1

ZeosLib Components Cached Updates

Posted: 23.02.2006, 12:46
by DiegoBM
I'd like to know which level of cached updates implementation comes with zeosdbo components.

I'll try to explain my problem with an example...
I don't really know if this is even possible on actual CachedUpdates implementations, but the matter is that when I post changes in a CachedUpdates-enabled Dataset without committing'em and then I try a Count(*) on the same table but another dataset, the count won't reflex the uncommited modifications.

The point would be a Connection-level CachedUpdates implementation capable to query together the Database and the entire transaction/connection-shared cache for results, as if the cached modifications where posted directly to the Database but remaining in the cache, some kind of "emulation?" of the database's on-post behavior.

Regards an well...sorry for my bad english :roll:

Posted: 24.02.2006, 13:49
by DiegoBM
Nobody knows?

:(

If not implemented yet, but scheduled, I guess I'd help...

Posted: 24.02.2006, 14:55
by zippo
Sorry, but I don't understand the question at all ...

Posted: 24.02.2006, 15:26
by gto
Hey zippo, means something like this:

Today, the component cached updates store the modifications in your own cache, each component has one cache, independant from others
without commiting to database, the modifications made in a dataset don't reflect in another.

I think that's the way it work's today.

The idea of DiegoBM is to link all component caches to make a "big application database cache", a level of access that any modification you do in a dataset, but don't commmit, can be viwed from another dataset, in the same program.

Well, I think it's this :)

Posted: 24.02.2006, 17:21
by DiegoBM
Yeah, it's exactly that, a connection-level cache. Thx gto :D

Posted: 24.02.2006, 17:47
by btrewern
Try using ClientDataSets if you want this feature see cloned cursors. It does this kind of stuff and other clever things.

Ben

Posted: 24.02.2006, 20:48
by zippo
What about server-side?

BEGIN TRNASACTION, COMMIT,.. etc. ?