Forums

ASP

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:
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

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

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

Reply to this topic