I thought of that.... I shall keep thinking more :). It would be great
to develop a mechanism that went for example. new Query("SELECT * FROM
BLAH WHERE ...").subscribe(new Listener() {...}); Which will then run
the query and then respond to any changes that affect that query. I
think that might be really hard work! Probably be easier to start off
with polling before trying to work out what other updates actually
affect the query.
So, a follow on question, is there a way to prioritise queries when
running in multi-threaded mode?. Say have a "background" query that
takes lowest priority over all other queries? As it is mainly the disk
that is the bottleneck I'm guessing setting thread priority would make
hardly any difference? Not really asking much for a lightweight, fast,
embedded, extremely flexible database huh? Bring on mvcc +
multi-threaded with a query prioritiser :)
Thanks
On 11/05/2012 2:04 AM, Noel Grandin wrote:
There are no built-in facilities, but you could hook a trigger into
your own custom java method which could broadcast updates.
On Thu, May 10, 2012 at 1:03 PM, Ryan How<[email protected]> wrote:
Hi,
This is more of a theoretical question at the moment, but in say MS Access
and FileMaker, if data is changed by another process when you are viewing
it, it automatically updates in the view. Is there a way in H2 to register
some kind of listener on a table, or on records on a table, to be notified
of when they are changed?. Then data in the client application can be
refreshed automatically without needing to poll data and keep requerying and
checking for changes against the loaded data set (which for a big query can
be quite intensive!).
Thanks, Ryan
--
You received this message because you are subscribed to the Google Groups
"H2 Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
