These are basically using the ADO componant and using SQL select statements
to query an Access database who's ODBC driver resides on the server.
Now these applications worked fine under IIS3.0. Now after my upgrade to
IIS4 and after testing IIS4 (PWS version) on my NT workstation with no
problems I am suddenly getting a very strange problem.
What happens is the first time the page is opened it waits...and waits.. and
waits... and eventually the script will timeout (90secs up!).
As the Query frame has loaded I can enter a parameter into the search field
and submit and all of a sudden it starts running like a ferrari! Even a
'Like' query runs at least 3 times as fast as before!
It is as if the first time the script is run it is caching the database
(Thus the timeout!) and then everything is fine.
Anyone got any ideas ?? I prefered the IIS3 method of mediocre performance
all the time.. <G>.
TIA,
Tony Reynolds