2. PHPRunner General questions
  3. [SOLVED]  prefetch of data
This topic is locked
[SOLVED]

 prefetch of data

 		1/25/2012 12:09:50 PM
PHPRunner General questions
F
 Francesco_5000 author

Hi to all
I recently had the need to read this article: http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/ . The problem I had was due to the slowness with which a list_page was loaded, in fact in the add page i've used some lookup wizard... and they are related to a myisam table with more than 8000 records.
The slowness was critical on Internet Explorer, the other browsers (Firefox, Opera, Safari and Chrome) have shown a better responsivity, I'm talking about the latest versions of those browsers. For reasons of usability i really need those lookup wizards, so I resolved not making those fields searchable. Now i'm wondering if:
A ) it's possible to avoid the prefetch of data specifically in list page?
B ) if no, can i develop an hand-made search function, that works on fields that a phprunner page won't see?
greetings
Sergey Kornilov admin 1/25/2012

Change Lookup wizard settings to use 'Edit box with AJAX popup' mode. No data will be fetched on the page load in this case.
F
 		Francesco_5000 author 1/26/2012



Change Lookup wizard settings to use 'Edit box with AJAX popup' mode. No data will be fetched on the page load in this case.


this is a solution but IMHO is far to be ideal because who does data-entry can do mistakes very easily, for example, deleting a character from the string. With a dropdown box i do not have this problem.
To be more clear i've used multiple chained dropdown boxes for a table where i've to manage geographical sites, so i have:

  1. Geographical areas -> 2) Regions -> 3) Provinces -> 4) Cities ;
    well... in Italy we have 8092 cities :-) as you can imagine the ajax suggestions in add/edit pages are very cumbersome for the data-entry guys. In addition to that, consider this example here: http://xlinesoft.com/tutorials/MultipleDropdowns.html . Cars are even more challenging than cities, if the table of the cars is huge, and this can happen because there are more than some few hundreds of models.
    I have a modest suggestion... for the next versions of phprunner give the possibility to the people to disable the prefetch of data on the list pages.
    [edit]
    i see the: "allow free input" check box... it helps if disabled, but to me it isn't the definitive solution.
Sergey Kornilov admin 1/26/2012

I'm afraid you are missing the point.
There are only two ways to handle this - either have the whole list when page is loaded or to use AJAX method when no data is prefetched.
I understand the idea of having a regular dropdown box that can be populated after the initial page load. However, imagine the situation when your data entry guy opens this dropdown box before data is fetched. Dropdown box will be empty and you get a "nothing works" call.
F
 		Francesco_5000 author 1/30/2012



I'm afraid you are missing the point.
There are only two ways to handle this - either have the whole list when page is loaded or to use AJAX method when no data is prefetched.
I understand the idea of having a regular dropdown box that can be populated after the initial page load. However, imagine the situation when your data entry guy opens this dropdown box before data is fetched. Dropdown box will be empty and you get a "nothing works" call.


well... 1) Geographical areas -> 2) Regions -> 3) Provinces -> 4) Cities ; are present in the Geographical areas table... >8000 records and so on, so i need to prefetch.
But I'm not talking about add/edit pages, I'm focused on the prefetch on the list page, because in that page i have

  1. Geographical areas;
  2. Regions;
  3. Provinces;
  4. Cities .
    as fields of records of another table. Furthermore in add/edit pages I haven't experienced big delays, but if you say that the prefetch of data it's always necessary (Add/Edit/List pages etc.) to work with chained dropdowns I think I can do data entry without them.