2. ASPRunnerPro General questions
  3. [SOLVED]  ASPRunner 6.3 Performance
This topic is locked
[SOLVED]

 ASPRunner 6.3 Performance

 		7/5/2011 01:51:30
ASPRunnerPro General questions
M
 mows author

Hi

We recently upgraded from ASPRunner 6.0 to 6.3.
A major issue which is prevening us from going live with 6.3 is the performance drop of 6.3.
Our client's environment is:
Web Server: Win 2003 server with IIS 6 : 2Gig RAM

Database Server : Win 2003 server with SQL Server 2005 : 4Gig RAM
I've read through the forums and have followed the suggestions at http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/ though the suggestions within that article seem more relevant to IIS 7 and don't seem to apply to IIS 6.
The speed issue is so bad that our client is choosing to stick with version 6.0 rather than 6.3.
Sergey Kornilov admin 7/5/2011

Those suggestions are not version specific and can be applied to all versions of IIS. Most probably you need to apply ASP specific notes at the end of article.
If you need more help troubleshooting this issue publish your application to Demo Account and send me the URL where I can see and troubleshoot this issue. 'Demo Account' button can be found on the last screen ('Finished') in the program.
M
 		mows author 7/5/2011

Just tried to upload to the Demo account. ASPRunner threw up the error show in the following screen dump when trying to upload to Demo...
Sergey Kornilov admin 7/12/2011

If Demo Account upload doesn't work for you for any reason contact support directly sending your database and project for investigation.
T
 		Tim 7/12/2011

Hey mows,
Just a thought: I was having similar slowness issues with a 6.3 app of mine and I went through the same blog entry (which is excellent, by the way, and I recommend it to anyone - especially the part about using FireFox to determine load times of various events) and what I determined is I had a significant view I was using (both in the list page and as a lookup field on add/edit pages, which was really a problem). It looks like - from your error when uploading to the demo account - that you also have a large "view" you are using. What I did was take the SQL statement from my view and use it to create a table, then I created a job (SQL server 2005) to recreate that "view" table periodically as was needed for my situation. Having ASPRunner look to a table instead of an SQL view (a view that did a bunch of calculating and joining of tables and such) really sped things up for me.
Again, just a thought.

Good Luck.

Tim
M
 		mows author 7/18/2011

Hi Tim
Thank you for the good advice.
Unfortunately we're not using any large views so not likely to be that issue.
You mentioned you found the blog helpful. What version of IIS are you running. We're running IIS 6 on Windows 2003 Server and the tips in the blog for IIS didn't seem to aplly.
Sergey Kornilov admin 7/18/2011

All suggestions provided by that blog post apply to IIS 6. If something doesn't work for you contact support sending your project files and database. We'll be glad to assist.