>>I hope you will share the information about the issue once you confirm it.
>
>Yesterday, we updated to the lastest VFPOleDB driver. We have the same as in our test environment. Then, we remove all the UPPER() tag from a big table. We got confirmation that the data in the related fields are always in upper now so we were able to get a tag instead on the field name. Those two adjustment didn't change anything. This morning, I got into the Web site and did a very simple request. It took long and all the upcoming ones were extremely slow. So, I checked the Hit log and saw that at the time I did the click, it's been an hour since the last one. So, this demonstrates that the problem is not related to some data problem, bad optimization in the code or anything in regards to that. So, it all comes down to something else running on the server, a setting that has to be changed on IIS, a bug in a component or something like that.
Thank you for sharing. I know how frustrating it must be when you are hitting a wall but no or very little control of the situation.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
