2.<\/strong> Reduce the number of records displayed per page. Display as many records as you can see on a single screen without scrolling. It improves user experience as well. If the users need to find a specific record they can use the search or loop through pages.<\/p>\n If you absolutely have to display a large number of records on a single page make sure you turn off \u201cLoading \u2026\u201d box.<\/p>\n 3.<\/strong> Reduce the number of fields visible on the list page. The golden rule is to fit all data on the screen without having to scroll either horizontally or vertically. You can display more detailed information for each record on the View page.<\/p>\n 4. <\/strong>Use features like \u201cShow Add\/Edit\/View pages in popup\u201d and \u201cAJAX search, pagination and sorting\u201d. This makes your application more responsive and overall faster.<\/p>\n 5.<\/strong> If you use search panel with lookup wizard controls this may slow down your application as well, especially if lookup tables are huge. The solution is to remove those fields from the search panel or use Lookup wizard type \u2018Edit box with AJAX popup\u2019. In this case no data will be pre-fetched on initial page load.<\/p>\n 6.<\/strong> Turn on \u2018Case-sensitive search\u2019 option under Choose fields->Search settings. By default PHPRunner search is case-insensitive ( WHERE upper(LastName)=upper(\u2018Newton’) ) which is slower though more convenient for end users. Turning this feature on results in faster searches.<\/p>\n The best approach is to use Firefox with Firebug addon. Open Firebug, proceed to Net tab and reload your page. Firebug shows you what files are loaded, in which order, as well as each file size and load time.<\/p>\n PHP page (cars_list.php) is loaded first. Browser parses HTML code and loads images, Javascript and CSS files. On the screenshot above you can see that cars_list.php takes 546 milliseconds to load. 375 milliseconds (Waiting) is the server processing time while 171 milliseconds is the transfer time from the server to your computer. As a rule of thumb – if server processing time is under one second there is nothing to worry about.<\/p>\n Another thing to keep eye on is the page size. If the size of the page is a few megabytes it will load quite slow. Also, make sure you are not using a search page with large lookup tables.<\/p>\n Lets consider another example.<\/p>\n You can see that server processing time is 36 seconds which is quite slow. Lets see what causes this.<\/p>\n As a first step you need to find the SQL query PHPRunner executes. Slow SQL query execution is the number one reason of bad performance.<\/p>\n To print the SQL Query on the web page change $dDebug to True in the include\/appsettings.php file. Reload the list page to see the SQL Queries at the top of the page. In our case we are going to see something like this:<\/p>\n On the list page PHPRunner executes two queries. First query calculates the number of records that matches the current filter. Second one retrieves the data. Note limit 0,10 clause at the end. No matter how large your database is PHPRunner only retrieves as many records as required.<\/p>\n If we execute those queries manually using phpMyAdmin or any other database tool we find that they in fact run slow (no wonder – our test database contains 12 million records). To speed up these queries we need to add indexes. Indexes are helping databases sort and find data faster. In this example we run a search for Residence_City field. Once we add an index on Residence_City field, our page takes less than a second to load.<\/p>\n Here is how you can create an index (MySQL specific):<\/p>\n More info: Creating indexes in MySQL<\/a><\/p>\n Note:<\/strong> make sure to turn on \u2018Case-sensitive search\u2019 option when you use indexes.<\/p>\n Make sure your web host supports HTTP compression. HTTP Compression is a publicy defined way to compress content (mostly textual)\u00a0\u00a0\u00a0\u00a0\u00a0 transferred from Web servers across the world wide Web to browsers. The impact of compression is that the number of transmitted bytes is reduced and thus a higher performance is gained.<\/p>\n More info on HTTP compression<\/a><\/p>\n On some web servers all ASP pages generated by ASPRunnerPro load extremely slow.<\/p>\n We found that switching the thread model on the application pool from MTA<\/strong> to STA<\/strong> resolved On some web servers output caching slows ASP application performance significantly. Try to turn output caching off to see if it fixes the issue. <\/p>\n","protected":false},"excerpt":{"rendered":" My application is slow. What do I do? Usually \u201cMy application is slow\u201d means one or more list pages take a long time to load. Here are the things you can check in order to improve performance. Is this issue server specific? Test your application on at least two different servers i.e. on your local machine and on the remote web server. If you do not have a local web server upload your application to Demo Account to compare the performance. Just in case test…<\/span>Continue Reading “Improving perfomance of PHPRunner\/ASPRunnerPro applications”<\/span> How to measure load speed<\/h3>\n
![\"\"](\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2011\/04\/scr1.png\" "\\"click")
<\/a><\/p>\n<\/p>\nSQL Query<\/h3>\n
SELECT count(*) FROM votersall WHERE (1=1) and Residence_City='Zolfo Springs'\r\n\r\nSELECT County_Code, ... FROM votersall WHERE (1=1) AND Residence_City='Zolfo Springs' ORDER BY Residence_City DESC LIMIT 0,10<\/pre>\n
CREATE INDEX Residence_City ON votersall (Residence_City(20));<\/pre>\n
What else I can do to increase the load speed?<\/h3>\n
ASP specific note<\/h3>\n
Thread pool model: MTA vs STA<\/h4>\n
\nthis problem. You will need to contact your web hosting provider in order to make this change.<\/p>\nTurn off IIS output caching<\/h4>\n