Issue
Cache Time for Record Changes - Xenta 527 for Vista - I/Net systems.
Environment
I/NET Seven integrated under Vista
Xenta Server 527 / 731
Cause
When using the Xenta 527 Web Server to view records in Vista from I/Net Seven, changes that are made do not show up immediately. Cached data does not reflect any recent changes made in the original SQL Host database. Once data has been stored in the local cache, the Cache timeout must expire before the data can be updated by retrieving it from the SQL Host.
The default time is set to 720 minutes, which allows the device to store data read from the SQL host for twelve hours.
Resolution
The default time is set to 720 minutes, which allows the device to store data read from the SQL host for twelve hours.
If the user wants to see the changes made and not wait for that period, they can connect to the device and change the Cache Time.
If the system is large, this may affect performance and cause slow down because of the volume of data that is coming through. Choose a time that is best suited for the application. However, by restarting the device it also gets an update from the SQL Host.
