When paging is not enough (WPE load)

[Charles Delfs]

I am finding on mature systems with lots of found records that the WPE gets bogged down when FMPS passes the found set to it. This can even cause PHP to timeout and throw an error. Plus no user wants to wait that long.

 

Normall I would deal with this with paging.

 

Pagination still has the full found set passing from FMPS to the WPE, then PHP sends just the current pages records to the browser. This is better but still boggs the Server down.

 

Best WPE efficiency comes from transferring small amounts of data.

 

But some times there be something else that slower performance down ...

 

 

C

[Charles Delfs]

Recently I found that  a sort on an unidexed field slowed a system down to a hault.

 

Things to watch for for PHP efficiency:

• Layout being called has only the needed fields an don others (if there are lots of records being returned)
• Fields on the layout are indexed 
• No fields contain erroneously large data
• Use pagination for faster (and shorter) web pages

 

 

 

 

CD