MySQL Forums
Forum List  »  Other Migration

Re: sql noticaition in mysql ? ? ? ?
Posted by: Shaul Porrat
Date: March 01, 2009 07:54AM

I have a working solution, but it needs ISAM files. Whenever the updater wants other users of the table to know that the data has been changed, the updating program UPDATES THE FILE LAST ACCESSED TIME on the ISAM file of the table, using Windows API.

The programs who have to know that the table is updated periodically query the file time of file containg the table, If the time changes since the last query, the consumer knows he has to requery the table and update his use of it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: sql noticaition in mysql ? ? ? ?
5721
March 01, 2009 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.