Tunidblookupcombobox very slow to load data

[Alr1976]

Hi, I have a problem using a TUniDBLookupComboBox. I need to do a lookup with a table containing more than 5000 records. I open the table and it takes less than a second, but when I do the lookup with the table already open, it takes more than 60 seconds. Alessandro

[Sherzod]

1 hour ago, Alr1976 said:

TUniDBLookupComboBox

Hello,

Please take a look at the demo examples:

\FMSoft\Framework\uniGUI\Demos\Desktop\DBLookupComboBox - Custom Remote Query 
\FMSoft\Framework\uniGUI\Demos\Desktop\DBLookupComboBox - Custom Remote Query (CDS)

 

[Alr1976]

Hi!

 

This is a tunidblookupcombo problem? with Large data i need to use Remote Query?

[Sherzod]

1 hour ago, Alr1976 said:

This is a tunidblookupcombo problem? with Large data i need to use Remote Query?

Lookup components are typically designed for relatively small datasets.
As the number of records increases, a server-driven (remote) query approach becomes more appropriate to keep performance and user experience acceptable.

[Farshad Mohajeri]

Hello, 

Please use a custom query where you can write the actual query code.