UDT Handler Slow

Michael

I have a UDT with around 3500 rows. The UDT handler I have for this table is very slow to open, I can see that each row is cycled through on opening the UDT and again any time a new row is added. I have 'Use DI-API' disabled and 'Use Change Tracking' enabled but it is still slow to update.

Can anyone advise on how to make it faster?

Comments

3 comments

Date Votes
  • Comment author
    Dave Gutman

    Have you filtered out unneeded rows and columns?  Maybe remove seldom-used columns and add a button to display those columns on another screen only when they need it?

    0
  • Comment author
    Michael
    • Edited

    All the columns are required, how do I filter out the number of rows that the UDT loads?

    Edit: I figured it out - I added a where clause before the 'order by' in the advanced options. Thanks for pointing me in the right direction it is much faster now!

    0
  • Comment author
    Dave Gutman

    Excellent!  

    You can also filter rows using the 'Foreign Key' column in the UDT Handler's main grid.  This accepts values entered (constants), dynamic syntax (so you can base it on a field's value), and SQL statements.

    0

Please sign in to leave a comment.