posted 15 years ago
Hi,
To reduce database load, you can simply create a table in your database as follows :
ServerID ServerAddress ServerStatus
1 192.168.1.6 Running or Idle
Now, check for the server status in this table, if the status is running then fetch the data, if its idle then wait for the status to be running.
(The application will modify the status in this table)
Also, you can keep a job scheduler in your database to look for the server status value and time out after some period to change the status.
Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"