2. PHPRunner General questions
  3. [SOLVED]  Table Links on List Page
This topic is locked
[SOLVED]

 Table Links on List Page

 		1/9/2015 11:33:01 AM
PHPRunner General questions
hfg author

My project is having speed issues due to the Table Links I have setup (PHPR 8)
I have four different tables linked to my main table and it is taking the program a long time to query each of the sub tables in order to show the results on the list for the master table.
I really do not need the 4 sub-tables shown on the master table list, just in Edit and view windows. I have tried turning off the List Page option on the Table Link properties, but all 4 sub-tables are still shown on the list page. I have even reset the list page view for the master table.
I also tried deleting the column the links are in and while it does remove the links based on the load speed I can tell it is still pulling the data from the sub-tables.
Is there a way to prevent the project from querying the sub-tables for each record on the master list page until the user hits the Edit or View links for a record and then only pull the information for that record?
thanks
N
 		nti 1/10/2015

Just guessing, it sounds like you may have "Query Designer", "Table Link Properties", join clause issue...?
Full joins vs left or right join...
hfg author 1/12/2015



Just guessing, it sounds like you may have "Query Designer", "Table Link Properties", join clause issue...?
Full joins vs left or right join...


Nope, they tables are linked via The Table link properties on the Tables screen of PHPR, not the SQL.
Sergey Kornilov admin 1/12/2015

Make sure you are not selecting 'Display a number of child records' under 'Table link properties'. You can see exact SQL Query executed using technique described in http://xlinesoft.com/phprunner/docs/debugging_tips.htm article.