2. PHPRunner General questions
  3. Loading speed with large tables
This topic is locked

Loading speed with large tables

 		6/3/2009 4:06:52 PM
PHPRunner General questions
H
 hammad author

Good day

I have just downloaded a new version of phprunner.
I have a databaze with many tables and records . As I know joinung tables will make rendering records very slow.
I have generated one simple project with one table which has about 1 500 000 rows, but the loading time is too slow. Table does not have any lookup values or joining, just plain text and ints.
I have used tha same table, not Custom View.
My question is how to make loading page and searching fast enough with phprunner.
Thanks
Ham
T
 		Tosomja 6/5/2009

Same problem
J
 		Jane 6/5/2009

Hi,
I recommend you to open generated include/dbconnection.php file, find db_query function and add following code to this function:

echo $qstring;


Then run your pages in browser, copy resulted SQL queries and execute it in the database directly. I suppose you need to optimize these queries and/or add indexes to the tables.
S
 		swanside 6/5/2009

I had a similar problem, My table has about 45 fields in it and over 22000 lines, We use a field called Job_No and Customer_Name.

I created an Index on Customer_Name and it speeded up alot.
gps088 6/9/2009

Hi, try creating index in each field that you are using in your search, also reduce the numbers of records to display on the lis page, this trick works for me and I'm manipuling around 410,000 records in 1 table and this table is growing up every day.