Forum Moderators: open
Cpu usage average is less than 5% Plenty of memory.
The files have the right permissions. Html files which go through IIS although they have no processing come out fine. Cold Fusion and PHP sites which of course dont get processed through IIS are fine as well.
At first I thought the MS access component needed upgrading since it was part of an ecommerce store, but found that the simple test script would take forever to load.
The timeout values are on MS defaults and site logs do not indicate many visitors at all.
Anyone have any ideas?
Thank you
KieranMullen
<%
Response.Write "This is a test ASP page."
%>
Access leaves open connections which will drive down the speed measurably.
Get a more server conducive database and you'll be fine.
Regarding the OP, I wrote a hello script which comes up very slow as well. So I doubt it has anything to do with access.
Sure, almost all other databases are better and more robust. But Access works just fine in many cases.
What would you suggest be done?
Thank you
KieranMullen
You can't imagine the headaches it brings. It is for storing mom's recipes, not running web apps. Choose MySQL or SQL Express if you're limited in budget, or if you want to plan for the future, go with MS SQL.
Yes it will serve up some pages to a few people at a time, and if you're making a quickie site for a dentist or something who gets 2 visitors a week, sure, why not. If it's a project that means anything to you, then build it right from the ground up.
KM
Thank you too. Have a nice day.
KieranMullen
As one of the previous posters mentioned - look in your performance monitor to see what exactly is the holdup. If you're not familiar with this tool, just Google on 'IIS6 Performance Monitor'.
If you've been mucking about with Access and there are some unclosed connections, your ASP scripts can seem to take forever to load. Try recycling the Application pool, and failing that, reboot the server (if that's possible) - then try your hello world script and see if anything changes.
PS. Cold Fusion and PHP do indeed get processed through IIS, they are ISAPI filters (or CGI). You're right though they typically don't interfere with one another in a direct way since it's so compartmentalized. Usually it would be just one sucking up all the CPU or RAM and crapping on the others.
PPS. Again, is there no way for you to ditch Access altogether? Unless you have some super-legacy intraoffice Access monster tied in with live business (which is normally impossible because you're not gonna be able to work on a live web Access DB), it's so much easier for ones blood pressure just to go with SQL Express (free) or MySQL (free).
Depending on what you're doing, it might be easy or hard to get a MySQL provider. I'm big on Dotnetnuke (www.dotnetnuke.com), and unfortunately the only 3rd party MySQL provider for that seems to be for older versions of DNN.
Really, truly, MS SQL is the superior option. I don't want to hijack the thread, which is about Access/Classic ASP trouble, so I'll leave it at that.
Hi there, I've just thought of something
It is possible that your asp.net install has broken.
If a simple 1 line asp classic script will not run smoothly an very fast, the it is possible that the asp.net framework on that server is broken,]
It doesn't happen easily, however, an update gone wrong, a corrupted update download, overwriting or deletion of required system files during server maintenance can corrupt the asp.net framework
for simple asp classic code like that, your server response should be lighning swift
This doesn't resolve itself, nor will a simple update suffice, you might want to dig thru msdn , i had many fun hours dealing with this,
Having said all that, your problem might be totally diferent, so these where just unsupported speculations which may or may not help
I believe the permissions are correct else it would not work at all.
The test script is
<%
Response.Write "This is a test ASP page."
%>
System can read from access table but when it comes time to write info it locks up and only iisreset fixes.
Some type of database connection needs repair?
Thanks
KM
As far as original question, I'd google for "slow asp pages". Have seen this in the past...way, waaaay in the past, don't remember the cause.
Have you actually setup an IIS application for the website?
All asp or asp.net sites must be setup as IIS applications, i read nothing about you doing this,
are you using a .asp extention or .aspx for the file
Is the html code on the test page okay, does the page load okay without the asp script
His plan of action was probably: 'Well, I've got a big problem, i'm going to post the same message on Aspfree.com, asp-forums-r-us.com, aspwidgets.com.. and. oh yeah, webmasterworld'.
When he got a response from me, he gave a smart-a$$ answer. Who cares right? He doesn't want help from -people-, he just types in some text and forums magically give the answers to his problem. So, using WW made his brain hurt and now there's people still here taking the time to help him and he probably solved his problem 2 weeks ago with a simple Google search.
Meanwhile, other people interjecting with interesting but completely off-topic questions such as 'Does MySQL work with .NET' etc.
I guess you win some and lose some.. this thread definitely takes the cake for frustration.
