Alpha Video Training
Results 1 to 14 of 14

Thread: Slow UX List Control

  1. #1
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Slow UX List Control

    Hi guys,
    Have a grid reading 64000 records...takes about 4 seconds to display.
    Trying to duplicate in List control on UX component.
    Nothing custom, just used the genie...this list control takes about 2 mins to open.

    Any suggestions to what I am doing wrong.

    Regards

    Neville

  2. #2
    Member jgrannis's Avatar
    Real Name
    Jeff Grannis
    Join Date
    Apr 2016
    Location
    New Iberia, LA
    Posts
    339

    Default Re: Slow UX List Control

    I would say that you probably want to choose 'Dynamic' for the List Virtualisation type. You will proabably just want to leave all the default settings to see the difference before trying to tweak it.
    You'll find it in the List Properties then in the List Properties tab.

  3. #3
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    Thanks for the prompt reply Jeff. Switched to dynamic , improvement...but still very slow.
    Sql Statement:
    SELECT FAMIDNO, IDNO, SURNAME, NAME1, RESCONGRNO, OFFCE
    FROM oac_Members
    As you can see, the sql statement is not big at all.

  4. #4
    Member jgrannis's Avatar
    Real Name
    Jeff Grannis
    Join Date
    Apr 2016
    Location
    New Iberia, LA
    Posts
    339

    Default Re: Slow UX List Control

    I have never worked with Grids here and usually prepare my List controls to be able to work when the user is offline.
    If the SQL is the same, I don't see why the grid would be faster than the list. But again, I don't know grids.
    Does the grid really query and then render the full 65000 rows and allow the user to scroll through them all without any delays?
    If the client device will always have access to the server, I suppose you could configure the "Paginate data" option on the Data Source tab.

  5. #5
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    Thanks Jeff
    Pagination seems to do the trick. For big tables what Pagination method would you use and how many records.
    I do realize that it also depends on the quality of your connection.
    Perhaps we can also hear from other users as to what the sizes of data tables are that they use with list controls, and what their experiences are
    Thanks
    Neville

  6. #6
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,573

    Default Re: Slow UX List Control

    Neville, in addition to using pagination on the list, you can also benefit from the UX's pre-render at design time Optimization property.
    I have found that the benefit for large UX components can be quite dramatic.
    Alpha Anywhere v12.4.6.0.2 Build 5943-5324 IIS v8.5 on Windows Server 2012 in Hyper-V

  7. #7
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,750

    Default Re: Slow UX List Control

    Do your users really need 64,000 records retrieved?
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  8. #8
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    Quote Originally Posted by mikeallenbrown View Post
    Do your users really need 64,000 records retrieved?
    No not at all. When I did not use those settings, as I am new ux. I tried the first time just using the genie, and of course it was reading the whole table, therefore the slow response.

  9. #9
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,186

    Default Re: Slow UX List Control

    You can set a flag in the before query event. The first time through you can limit it. I usually limit to the height of the list box, like 12 records. Then on the search it can look for just the criteria.
    BeforeQueryEvent.JPG

  10. #10
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    Hi Guys,
    Thanks for your help.
    Having a problem with the list control.
    Mapping Problem.JPG
    I have checked the mapping and selected the primary keys but still the error persists.
    SQL Statement:
    SELECT mem.SORTNAME, mem.IDNO, (((((((((( rtrim(mem.HPremises) + ' ') + rtrim(mem.HStreet) ) + ' ') + rtrim(mem.HSuburb) ) + ' ') + rtrim(mem.HTown) ) + ' ') + rtrim(mem.HCountry) ) + ' ') + rtrim(mem.HPcode) ) AS Expr1, cngr.RESCONGRNO, cngr.CONGRNAME, prst.PrstNo, prst.AdminSortName, cngr.RowGuid AS cngr_RowGuid, prst.RowGuid AS prst_RowGuid, mem.RowGuid AS mem_RowGuid
    FROM (oac_Members mem
    LEFT OUTER JOIN oac_Congregations cngr
    ON mem.RESCONGRNO = cngr.RESCONGRNO
    LEFT OUTER JOIN oac_Priestships prst
    ON mem.RESCONGRNO = prst.ResCongrNo AND mem.PRSTNO = prst.PrstNo )
    Mapping Problem 2.JPG
    Mapping Problem 3.JPG

    When you create an UX with a list that has a detail view, the fields on the List are "Pulled" through to the detail view.
    Question:
    Can I make a list against table A, and the detail against fields on table B. When the detail is opened I can for instance do a Ajax callback to get the details for table B, edit and save.
    What I want to do is create a SQL view on the backend, use that on the list, and then do the crud actions against the actual table.
    Is this possible?
    Regards

  11. #11
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,186

    Default Re: Slow UX List Control

    Absolutely possible. Depending on how you build your view you can have CRUD operations against a view in MS SQL. Are these tables (oac_Congregations, oac_Priestships) read only? Do you have their keys identified?

  12. #12
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    Yes absolutely, it is my server...full control.
    All my tables have a rowguid column as the primary key

  13. #13
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    91

    Default Re: Slow UX List Control

    I read up about CRUD through views, there are quite a few restrictions.
    Is my first option of "List on View" and "CRUD on table" not a more viable option.?
    The view consists of a few joins, but I am only going to update the one table.

  14. #14
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,186

    Default Re: Slow UX List Control

    That will work too. Lots of options. I only use views, but what you are doing will work too. I'd start by removing the joins from the list until I could find out where the problem is.

Similar Threads

  1. List refresh is jumpy and slow
    By bob9145 in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 12-30-2018, 01:54 AM
  2. Replies: 7
    Last Post: 10-17-2018, 10:30 PM
  3. Dynamically populating a list control from another list control
    By Hank_the_Cowdog in forum Mobile & Browser Applications
    Replies: 6
    Last Post: 08-06-2018, 10:23 AM
  4. Filterin a list control on a field in the list control
    By Anis in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 04-29-2015, 04:43 PM
  5. Slow List Array
    By MIKE LYON in forum Alpha Five Version 4
    Replies: 10
    Last Post: 06-30-2002, 02:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •