Why not a trigger ?

See http://www.h2database.com/html/features.html#triggers

On 2 déc, 16:58, Lennart Schedin <[EMAIL PROTECTED]> wrote:
> I have the following problem:
>
> I have a large table (typically 20 Mb of data). I have one Java
> program that needs the data but only for reading. The Java program
> contains a thread that periodically reads the entire table into main
> memory (about 1 read per minute).
>
> This causes a lot of network traffic (since I have several Java
> programs).
>
> Is there any way to determine if a table has changed since my last
> read? In Mysql for example there is a CHECKSUM TABLE feature that can
> be used to only transfer the checksum of the table. That way I can in
> my Java program determine if I must read the entire table or not.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to