.net hold query results?

[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.

 

[Cor Ligthert[MVP]]

Andrew,

You problem can be in three places with different newsgroups.

It is the database section of the webservice and then it is this newsgroup.
It is in the windowsservice or is the webservice.

For the latter I would ask this in your case in the language group of the
language you are using.

By instance
microsoft.public.dotnet.languages.vb
or
microsoft.public.dotnet.languages.cs

for the webservice is an alternative
microsoft.public.dotnet.framework.aspnet

In my idea you would start to solve this in the service to see if you have
time outs (just a try around it and use the event viewer to show the
results).

Cor

 

[Miha Markic]

How do you query the database?

 

[Norman Yuan]

Whether .NET (should be read as .NET app, which is the Window service) is
holding the query result depends on the app's design/code. So, if you can
read the code, you should know. Or, at least the programmer knows. The
symptos as you described indicate the app could be written wrong. The way to
solve it, well, would be study the code, do neceesary testing and debugging.