Question
How big can or should a local data store be?
We are working on an application that has a local datastore for products in the catalogue. We thought there would be about 20 products.
Now it turns out that the number of products in one division is much, much more higher: up to 35,000.
This makes me wonder: does it make sense to keep this in a local data store, or should we define this database external to Pega.
And what is the tipping point?
Local data storage is a feature that lets you store data records for a data type within Pega 7 without having to manually create or maintain database tables.Access local data storage from the data type landing page of the data type the storage is for, in the Data Explorer.
However, going by the number of data you have, it is a good idea to use database rather than storing them locally. It will un necessarily create some performance overhead .
Hi RobertJanStreng,
I found this older post that may help:
Difference between local data storage and data tables
Let me know if that helps!
Marissa | Community Moderator | Pegasystems Inc.