Challenges faced in writing queries while using external DB to store data

Hi Team,

I hope many of you might be using external DB to store project data as it is huge in size. But you might have faced challenges like writing required queries AddorUpdateDataTableEntries, queryDatatableEntries,PurgeDataTableEntries.

1. You had some generic AddOrUpdateDataTableEntries like in thingworx or you have been writing queries specific to each data table operations.

2. QueryDataTableEntries - In Where condition some queries might use a single column and in some other queries there might use many columns. Otherwise please confirm if you are using specific queries for each Query of DataTables that contain different fields.

As we are in the initial phase of setting that up, it would be helpful for people like us to understand and be prepared for the same.

Regards,

Radhakrishnan.