UDT Handler Slow
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?
Comentarios
3 comentarios
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?
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!
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.
Iniciar sesión para dejar un comentario.