This topic is locked

Aspr Application Performance

4/8/2013 9:07:43 AM
ASPRunnerPro General questions
M
marcove author

Hi,

I use ASPR 7.0, for a very big database (more than one 1Mln records).
I've very strong problem concering time working of the application.
What can I do to improve performance? I don't know if I could use StoredProcedure to be called from List_page, so application can list (serverSide) pre-executed store for short list instead to execute select to all records.
This because if I write self created ASP pages (not from ASPRunner), I have shorter times from application, cause I think becase I don't use text search.. used in ASPRunner List Pages?
Pls could you suggest me which are solution to have best performace from ASPRunner?
Thank you

M.

Sergey Kornilov admin 4/8/2013

I recommend to start by reading this article:

https://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/
Once your figure out performance bottleneck be that database or web server settings you can start working on fixing it. Finding what exactly causes the trouble is the first and the most important step.