CPS-887 Decreasing performance of cmHandle registration after large number of schema sets in DB
https://lf-onap.atlassian.net/browse/CPS-887
References:
Proposed solutions
Description | Notes | |
|---|---|---|
| 1 | Change yang_resource table in dataspace to include dataspace_id |
|
| 2 | List all module references irrespective of the dataspace | |
| 3 | Change current algorithm and move the check to database level |
|
Solution 3
Investigation
Storing bookstore model on 2 different dataspaces
On start up of the application through CSIT setup the yang_resource table on the database has the followig resource
id | name | content | checksum | module_name | revision |
|---|---|---|---|---|---|
24 | stores | ..... | ..... | stores | 2020-09-15 |
Then the following steps were taken:
Description | Results | Notes | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Created two dataspaces
| ||||||||||||||||||||
| 2 | Created two schemasets
For both schema-sets the 'bookstore.yang' model was used |
| After creating two schema-sets using the same model, the yang_resource table contains the following
** id 24 was preloaded and has a different 'name' |
Conclusion: Based on the test above, dataspace id is not needed anymore.