Refreshing database cache

  • Thread starter Thread starter MW
  • Start date Start date
M

MW

Dear all

I have written a windows service that connects to an Oracle 9 database on
start up. I use a DataTable to hold a set of near static data.

Recently there have been some overnight external batch updates to this table
and my DataTable needs to be refreshed. Since this change of circumstances I
have been restarting my service in the morning. I need to find a way to
fresh my data object without restarting the windows service. I would be
grateful for any pointers.

Regards,
Wazir
 
The updates to the table happen external to my service and thus I dont know
when to redo the select.
Is there any set mechanism to expire the object say every 24 hours and
reload the contents?
 
Hi,

MW said:
The updates to the table happen external to my service and thus I dont know
when to redo the select.
Is there any set mechanism to expire the object say every 24 hours and
reload the contents?

System.Timers.Timer?
 
Back
Top