Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

IIS6 with ASP/Access very slow

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  need sample of activex WSHShell.CreateShortcut  
Author Message
dante

External


Since: Jun 08, 2004
Posts: 2



(Msg. 1) Posted: Tue Jun 08, 2004 6:09 pm
Post subject: IIS6 with ASP/Access very slow
Archived from groups: microsoft>public>inetserver>iis (more info?)
We have a small (19 records!) database that is queried by asp on our web
site and it has suddenly got very slow ... a query can take 30 seconds for
the page to build!!

There are a lot of posts regarding IIS6 and Jet and I wondered whether
anybody could point me in the right direction to get to the bottom of this.

Running IIS6 on Server 2003 Web edition. All fully patched using windows
update. Server has 2 x 2.4 Xeon and 1 gb RAM. Database was built using
access 4.

Thanks

Colin

 >> Stay informed about: IIS6 with ASP/Access very slow 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Tue Jun 08, 2004 6:09 pm
Post subject: Re: IIS6 with ASP/Access very slow [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Colin Jack" <dante.DeleteThis@mainline.co.uk> wrote in message
news:eFkBlIWTEHA.3664@TK2MSFTNGP12.phx.gbl...
 > We have a small (19 records!) database that is queried by asp on our web
 > site and it has suddenly got very slow ... a query can take 30 seconds for
 > the page to build!!
 >
 > There are a lot of posts regarding IIS6 and Jet and I wondered whether
 > anybody could point me in the right direction to get to the bottom of
this.
 >
 > Running IIS6 on Server 2003 Web edition. All fully patched using windows
 > update. Server has 2 x 2.4 Xeon and 1 gb RAM. Database was built using
 > access 4.

Could be the bug - but it's hard to tell. It usually causes a crash that
can be diagnosed with IISState.

Inefficient ASP/ADO coding techniques could also be responsible. Can you
post some sample code?

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: IIS6 with ASP/Access very slow 
Back to top
Login to vote
dante

External


Since: Jun 08, 2004
Posts: 2



(Msg. 3) Posted: Wed Jun 09, 2004 4:13 pm
Post subject: Re: IIS6 with ASP/Access very slow [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have gone further and installed MySQL with the ODBC connector and
converted the database. All fine again.

Thanks for your help

Colin

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:ca4h51$984@kcweb01.netnews.att.com...
 > "Colin Jack" <dante RemoveThis @mainline.co.uk> wrote in message
 > news:eFkBlIWTEHA.3664@TK2MSFTNGP12.phx.gbl...
  > > We have a small (19 records!) database that is queried by asp on our web
  > > site and it has suddenly got very slow ... a query can take 30 seconds
for
  > > the page to build!!
  > >
  > > There are a lot of posts regarding IIS6 and Jet and I wondered whether
  > > anybody could point me in the right direction to get to the bottom of
 > this.
  > >
  > > Running IIS6 on Server 2003 Web edition. All fully patched using windows
  > > update. Server has 2 x 2.4 Xeon and 1 gb RAM. Database was built using
  > > access 4.
 >
 > Could be the bug - but it's hard to tell. It usually causes a crash that
 > can be diagnosed with IISState.
 >
 > Inefficient ASP/ADO coding techniques could also be responsible. Can you
 > post some sample code?
 >
 > --
 > Tom Kaminski IIS MVP
 > <a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running
IIS
<font color=purple> > <a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/</font" target="_blank">http://mvp.support.microsoft.com/</font</a>>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/</font" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</font</a>>
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS6 with ASP/Access very slow 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS6 Slow - I have an intranet application running on Windows 2003 with IIS 6. The application is written in traditional ASP. The database is on SQL 2000. I use MSXML4.0 to parse the query result in to XSLT. Most of the time the performance is ok. However, when...

Slow Publishing from FP to IIS6.0 - I have a number of users using FP2k and FP2k2, the problem is that some times suffer from very slow publishing times when publishing to my IIS6.0 server. I have tightened and repaired the settings in IIS6.0 and it seems to improve things for the initial...

Slow response with IIS6.0 - Hello I have an asp.net website installed on a webserver 2003. I notice that the response is very slow on some pages when I asked them from internet. But when I run the site from the server, it is very fast. The site was on a serveur 2000 before and no..

IIS6 Disappointing - VERY slow for ASP pages - Like many others here, I've been tearing my hair out trying to find why IIS 6 is so slow serving ASP applications across the network. When accessing the application from a browser on the IIS server (local access ) the pages come up qiuckly. The same..

IIS6 slow connection from network - Hi, I have to following problem: On a new installed Windows 2003 Server with IIS6, both with default configuration. I've installed a ASP web application with DB access. If I try to connect to this web application, the response is slow, but if i try..
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]