A
Andrew
Hello, friends,
We have a windows service which will query database through a web service
every one minute. If there are new records, this windows service will process
accordingly.
However, if there are no new records for a long time, say 2 days in weekend,
this windows service will no longer be able to retrieve new records anymore.
Although it still does the query, but return no records.
We then have to stop and restart this windows service to make it work again.
We believe .net hold query results somewhere, probably in web service.
Rather than actually going to the database to query again, it just returns
whatever cached in memory.
Are we right, and how to solve this problem?
Thanks a lot.
We have a windows service which will query database through a web service
every one minute. If there are new records, this windows service will process
accordingly.
However, if there are no new records for a long time, say 2 days in weekend,
this windows service will no longer be able to retrieve new records anymore.
Although it still does the query, but return no records.
We then have to stop and restart this windows service to make it work again.
We believe .net hold query results somewhere, probably in web service.
Rather than actually going to the database to query again, it just returns
whatever cached in memory.
Are we right, and how to solve this problem?
Thanks a lot.