What is updating the table? Another [apache module] thread or another process?
If they are from the same module, I'd think you could use a static int or semaphore. There's also shared memory. > -----Original Message----- > From: Kazuho Oku [mailto:[EMAIL PROTECTED] > Sent: Monday, September 27, 2004 3:25 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Receiving notification of table updates > > Receiving notification of table updates > > I have an apache module that accesses an SQLite table everytime it handles > an HTTP request. > In order to speed up the operation, I would like to have the module cache > the table, and only re-read it when the table is being updated. > > The question is: what is the best way of notifying the apache module of > table updates? Is there such an API? > I cannot use UNIX signals since it is an apache module. > > I am currently considering of creating an empty file which gets touched > (mtime updated) every time the database table is modified, and have the > apache module check the last-modified time of the file to determine. > > If anybody knows of a better way, please help me. > > __________________________________________________________________________________________ This electronic message may contain proprietary and confidential information of Verint Systems Inc., its affiliates and/or subsidiaries. The information is intended to be for the use of the individual(s) or entity(ies) named above. If you are not the intended recipient (or authorized to receive this e-mail for the intended recipient), you may not use, copy, disclose or distribute to anyone this message or any information contained in this message. If you have received this electronic message in error, please notify us by replying to this e-mail. (1)
