2. ASPRunnerPro General questions
  3. [SOLVED]   Performance Of Asprunner 7.2
This topic is locked
[SOLVED]

  Performance Of Asprunner 7.2

 		6/20/2013 8:57:01 AM
ASPRunnerPro General questions
lefty author

I have a large project in 7.2 / Ms Access with 30 tables / Audit table / one Master / child relationship table and some events and queries that are somewhat complicated but are running correctly. I have read all the articles and came to a couple of conclusions.
Windows 2003 server / IIS 6.0

  1. Shared Hosting can be a problem . Why If you ask them to cache your static and dynamic pages they seem like this is minor and won't chane much. So I did and guesss what actually slowed down my application more.
  2. I asked to change from MTA to STA in application pool . They said it was already using STA . So no help there.
    4.I checked in firebug the load times of the pages. It seems the list page is the slowest and when I dug deeper the sprites that load are even slower.

    So that go me wondering about the actuall styles I am using and sprites that load. I am getting page loads at anywhere from 10 to 39 seconds depending on the size of the data . I dropped data down to 10 per page . I do use some AJAX and have eliminated some of those calls but still slow.
  3. The big problem . Some users logon go to a tab or section and go the list page of a table and bang.....They get loogged out Session expired. They then have to login again . It happend almost everytime. It seems is does not hold the session on first login but holds it on second login.
  4. I have taken out search panel and loading box as that appeared slower . I also to out ICons for edit view add as a test . Still have same problem.
    7.. My database is getting larger but not over 20 mb so it's still small. Concurrent users have increased but never over 5 in one session that I have found.
    Any other Ideas . Like indexing queries ???? or different dbconnection. As I use the one generated by asprunner. for msaccess.
    Would appreciate help with this. I cannot load this to demo account I think it is too large over 1500 files . I think it is ove 50mb.
Sergey Kornilov admin 6/20/2013

John,
unfortunately it's hard to tell what exactly causes this without having access to your application. I assume that you already checked an article in our blog related to performance issue: http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/
If your project is to big to be posted to Demo Account feel free to send it directly to us using Dropbox or any other file transfer service.
lefty author 7/11/2013

Turns Out This is not an Asprunner 7.2 problem.
Using another shared hosting environment inspirunner__ hosting which is great way to test and host your site was the answer. There are a lot of hosting companies out there that just don't know or care about asp / php settings in thier IIS es.. 6.0 7.0 etc... most of them are hosting HTML pages. When I swithced to the above hosting my speed increased quarduple fold. I went from 9.8 seconds load on msaccess database to 1.29 seconds on a table that holds 5000 records.
Kudos to ASprunner / PHpRunner / Asp.netRunner for there suggestion for hosting . If you need a quick database website then I have to say that is the way to go.
Check your settings above for IIS but this hosting company obviously knows how to set correctly and without a virtual server it's a quarter of the cost. May want to check PLESK notes before but not too hard to set.