Forums
This topic is locked
Very slow connection to an access db on win 2003
Posted 12 May 2006 17:13:25
1
has voted
12 May 2006 17:13:25 James Noon posted:
HiI have recently moved servers and isp from my old windows 2000 server to a
much higher spec windows 2003 server.
I have migrated all my sites over.
One site in particular is much slower at pulling results back from an access
database. It uses the same dsn and file structure, its an exact duplicate.
If on the new site you go to
www.vinylnet.co.uk/GBpunk/GBpunk_results.html
then click E-G
It takes about 10 seconds to generate the page
If do the same on the old server
www.collectablecds.co.uk/GBpunk/GBpunk_results.html
The results appear in about a second.
The engineers are looking into this but cannot see whats casuing this issue.
On another matter, since the move, I have ms sql installed on the box and
some of the sql sites are being intermittantly very slow, but then sometimes
theyre fine.
One of the sites using ms sql is www.eaglemusicshop.com
Any advice appreciated.
PS I am hosting with www.rackspace.co.uk
Thanks, James
Replies
Replied 13 May 2006 01:06:18
13 May 2006 01:06:18 Pier Hagi replied:
HI James
sorry but I'm not speak english very well!
I have the same problem of you. I moved my web site from server Win 2000 to Win2003 :
An error has occurred while saving the uploaded file!
I tried to modify as here:
www.fwzone.net/showDetail.asp?NewsId=4175&ZoneId=1
but nothing.
So I tried to add in insert in upload extentions in "Upload Folder":
server.MapPath("/upload"
...but nothing!!! ;-(
Have you same idea?
Pier
sorry but I'm not speak english very well!
I have the same problem of you. I moved my web site from server Win 2000 to Win2003 :
An error has occurred while saving the uploaded file!
I tried to modify as here:
www.fwzone.net/showDetail.asp?NewsId=4175&ZoneId=1
but nothing.
So I tried to add in insert in upload extentions in "Upload Folder":
server.MapPath("/upload"
...but nothing!!! ;-(
Have you same idea?
Pier
Replied 29 Jul 2006 01:37:09
29 Jul 2006 01:37:09 patrick vicktorus replied:
I James,
i have the same problem than you ! Do you found de solution in windows 2003 ?
i saw lot of board talking about the problem, but no solution.
Thank's for your help
Patrick D.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi
I have recently moved servers and isp from my old windows 2000 server to a
much higher spec windows 2003 server.
I have migrated all my sites over.
One site in particular is much slower at pulling results back from an access
database. It uses the same dsn and file structure, its an exact duplicate.
If on the new site you go to
www.vinylnet.co.uk/GBpunk/GBpunk_results.html
then click E-G
It takes about 10 seconds to generate the page
If do the same on the old server
www.collectablecds.co.uk/GBpunk/GBpunk_results.html
The results appear in about a second.
The engineers are looking into this but cannot see whats casuing this issue.
On another matter, since the move, I have ms sql installed on the box and
some of the sql sites are being intermittantly very slow, but then sometimes
theyre fine.
One of the sites using ms sql is www.eaglemusicshop.com
Any advice appreciated.
PS I am hosting with www.rackspace.co.uk
Thanks, James
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
i have the same problem than you ! Do you found de solution in windows 2003 ?
i saw lot of board talking about the problem, but no solution.
Thank's for your help
Patrick D.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi
I have recently moved servers and isp from my old windows 2000 server to a
much higher spec windows 2003 server.
I have migrated all my sites over.
One site in particular is much slower at pulling results back from an access
database. It uses the same dsn and file structure, its an exact duplicate.
If on the new site you go to
www.vinylnet.co.uk/GBpunk/GBpunk_results.html
then click E-G
It takes about 10 seconds to generate the page
If do the same on the old server
www.collectablecds.co.uk/GBpunk/GBpunk_results.html
The results appear in about a second.
The engineers are looking into this but cannot see whats casuing this issue.
On another matter, since the move, I have ms sql installed on the box and
some of the sql sites are being intermittantly very slow, but then sometimes
theyre fine.
One of the sites using ms sql is www.eaglemusicshop.com
Any advice appreciated.
PS I am hosting with www.rackspace.co.uk
Thanks, James
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 29 Jul 2006 16:27:05
29 Jul 2006 16:27:05 James Noon replied:
Hi Patrick
Sorry u have had the same problem, it really drove me insane!! In the end I have had to upgrade the site to use SQL Server which now works fine.
I had the Microsoft Level 3 certified engineers at Rackspace looking into the issue for sometime and between us both we just could not find a permanent solution.
We tried changing the db connection from a dsn to a dsn less connection, ole db etc etc. Changing the connection made the site run fast, but after a day or so it ran slow again. We found that, on the server, if we refreshed the application pool it ran fast again. So we played around with the application pool settings telling it to auto-refresh after a certain time, but whatever we tried, at some stage the site would run very slow again and sometimes time out.
Essentially after all the testing and trying various configurations we did not sort the problem and I had to upgrade to SQL server which now works perfectly & consistently fast.
Regards & Good Luck
James
Sorry u have had the same problem, it really drove me insane!! In the end I have had to upgrade the site to use SQL Server which now works fine.
I had the Microsoft Level 3 certified engineers at Rackspace looking into the issue for sometime and between us both we just could not find a permanent solution.
We tried changing the db connection from a dsn to a dsn less connection, ole db etc etc. Changing the connection made the site run fast, but after a day or so it ran slow again. We found that, on the server, if we refreshed the application pool it ran fast again. So we played around with the application pool settings telling it to auto-refresh after a certain time, but whatever we tried, at some stage the site would run very slow again and sometimes time out.
Essentially after all the testing and trying various configurations we did not sort the problem and I had to upgrade to SQL server which now works perfectly & consistently fast.
Regards & Good Luck
James
Replied 29 Jul 2006 16:31:53
29 Jul 2006 16:31:53 James Noon replied:
Hi Pier
The issue u mention I think is unrelated to the win 2003 slow db issue.
Regards
James
The issue u mention I think is unrelated to the win 2003 slow db issue.
Regards
James