locked
Querying Larger Data Faster/Efficiently RRS feed

  • Question

  • First off I am not a developer, but am learning as i go along with JS, html, etc..


    So, I have a query setup to query all employees of a certain OU, there about +4,500 items that get pulled in for the end user, however the problem is that it takes a bit of a while to load the items to the query table. Taking an average of 6400ms to load and display

    I noticed that it is bringing in all the data at once, which seems to slow down on the big three browsers (IE, FF, Chrome)

    http://i.imgur.com/oIkSiFU.png

    On Datatables documentation i  see that there is a feature called, server-side processing, which is more commonly used for much-much larger data sets, but seem to improve performance.

    https://datatables.net/examples/server_side/simple.html

    Would it be possible to implement the portion where you would click one of the pages, then it would load the data, or much preferably when you use its search function with the existing way it is setup in the SSP?

    Below is a profile performance sample from Firefox.

    https://onedrive.live.com/redir?resid=643DCC4CA9A27B19!107&authkey=!ADOq5RCNESKRAyU&ithint=file%2cjson


    Thursday, May 5, 2016 5:20 PM

Answers

  • I did a visual edit to the portal to introduce searching:

    http://www.ephingadmin.com/service-manager-html5-portal-search-query/

    The idea is you have a text box someone can put their text into and then change the "refresh" button into a search button. Now, instead of pulling in everything and then filtering down, the list is filtered based on the search in the text box.

    Monday, May 9, 2016 2:49 PM

All replies

  •    +1 on your goal. I am with you. Same problem with us, 9400 CI get fetched. it takes i think 8 to 9 seconds.

       however more important first is not to shift processing part to server side, because it would sure be complicated to do because currently search is very fast, and multiselect is also a possibility. So keep both these and doing server side would be very complex i think.  

       I think first and foremost important is to fix ajax part in the portal code! because you would have observed that it is not fine tuned for large results. there is just a gray screen for whole duration, not animating dots or wait message. 

       Circling dots appear initially and then rest duration it is whole gray screen and naïve users might think it's all stuck. some bug is there which need to be fixed. As soon as user clicks on refresh button its dangerous amount of wait. on all rest items where there is minor wait, circling dots appear correctly, but where it is needed the most, it's not correctly implemented.

       


    Shahid Roofi


    Sunday, May 8, 2016 10:10 AM
  • I did a visual edit to the portal to introduce searching:

    http://www.ephingadmin.com/service-manager-html5-portal-search-query/

    The idea is you have a text box someone can put their text into and then change the "refresh" button into a search button. Now, instead of pulling in everything and then filtering down, the list is filtered based on the search in the text box.

    Monday, May 9, 2016 2:49 PM