UDT Handler Slow

Michael

• September 10, 2021 09:26

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?

Vote

0

• 

  Dave Gutman

  • September 10, 2021 12:01

  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?
• 

  Michael

  • September 10, 2021 14:40
  • 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!
• 

  Dave Gutman

  • September 10, 2021 19:45

  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.

Please sign in to leave a comment.