Dataset values more than 10000

[AshishDas]

Hi,

We have around 18000 departments which we wish to populate in a dropdown in the create user form from a dataset table that we have imported.

However, dataset gives us a threshold of only 10k lines of entries.

Any workarounds for this use case?

Can we break the list into two datasets and fetch the value in create user form via SQL query?

[Enakshi]

Yes we can break it into two datasets and fetch the data

[rushikeshvartak · Accepted solution]

select attribute1 as id from dataset_values where datasetname='DEPT1' union
select attribute1 as id from dataset_values where datasetname='DEPT2'

make sure you use index else page load time will increase (work with saviynt ops)

[sk]

Yes please make sure that indexing is done otherwise page loading will not work properly

[AshishDas]

Could you elaborate how indexing can affect?

[rushikeshvartak]

Saviynt load dynamic attribute value on page load if your dynamics attribute values are more then page load time will be more so add index on table column

Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they are just used to speed up searches/queries. Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update).