Optimize Central APIs

[anupama-pathirage]

@xlight05 cloned issue wso2-enterprise/ballerina-registry#2298 on 2023-11-08:

Description:

$Subject.

The following are the objectives :

1. Decrease API time

2. Reduce the number of db calls

3. Optimize DB calls to make them faster/less resource-consuming

[anupama-pathirage]

@xlight05 commented on 2023-11-08:

Following are the planned optimizations

Caching

• https://github.com/wso2-enterprise/ballerina-registry/issues/2299 - PR Sent

• https://github.com/wso2-enterprise/ballerina-registry/issues/2307

Architectural changes

• https://github.com/wso2-enterprise/ballerina-registry/issues/2279

• https://github.com/wso2-enterprise/ballerina-registry/issues/2274 - PR Sent

• https://github.com/wso2-enterprise/ballerina-registry/issues/2308

Query Optimizations

• https://github.com/wso2-enterprise/ballerina-registry/issues/2314

• https://github.com/wso2-enterprise/ballerina-registry/issues/2296 - In progress

• https://github.com/wso2-enterprise/ballerina-registry/issues/2310