Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Dataset values more than 10000

AshishDas
Regular Contributor II
Regular Contributor II

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?

5 REPLIES 5

Enakshi
Saviynt Employee
Saviynt Employee

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

rushikeshvartak
All-Star
All-Star

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)


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

sk
All-Star
All-Star

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

AshishDas
Regular Contributor II
Regular Contributor II

Could you elaborate how indexing can affect?

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).


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.