In reply to: ruthw
Thank you so much both! I have limited columns (form fields) but I would have about 70,000+ rows (workflow instances) that will keep growing. Would that be too large data to be loaded to a dictionary. If not is there best way to load the data or any article on it?
Thank you!
For this amount of data, I would rather create some technical database with a table for this dictionary.
And optionally on webcon a form for searching , adding/deleting/updating data, If they were to be fed manually.
For this approach you can define the most optimal indexes for this dictionary.
And , in my opinion , if only you can slim down the content database from some more data that doesn't necessarily have to be there , it has only advantages.
Regards.