If you have the sgi_fam, you could place a file in a directoy everytime
you add a row. the sgi_fam module would inform your app that there was a
change on the filesystem. When the notification is made, your app can
then get the new value from the database.
I believe that one user suggested that you have a status flag for a row.
Your app could reset the flag when it retrieves the row.
record_status enum("0","1");
$time = select now() from table;
select * from table where record_status = "1";
update records set status = "0" where timestamp_column < $time;
Curtis
Chris Webster said:
> Curtis Maurand wrote:
>> What's the client running on?
>
> Not the same machine as the server. Could either be a windows or
> linux box across ethernet.
>
> --Chris
>
>>>Curtis Maurand wrote:
>>>
>>>>I'd write a perl script to pool the device and send the data to the
>>>>database.
>>>
>>>Sorry for not being clearer. I can get the data into the database
>>>fine. Assuming new values or rows are added once per second, how
>>>would a client program go about polling the database to see when a new
>>> value was ready? Check # of rows for a column and when it's
>>>incremented grab the latest value?
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
