[Task]: Investigate datasources part of the consolidated API to see why it takes time

[sneha122]

SubTasks

https://theappsmith.slack.com/archives/CPQNLFHTN/p1715761934675989

[sneha122]

As per discussion in thread, we have decided to add instrumentation to all the areas where we feel bottlenecks are there, this will reveal to us if these are indeed causing performance issues and based on that we can make improvements

[sneha122]

As per discussion in thread, after adding instrumentation and checking this instrumentation from local, we have decided on following areas of improvements:
In order to solve identified bottlenecks, we can:

• Remove unnecessary individual calls to fetch plugin info from DB everytime, instead we can fetch all plugins at once and send this data populateHintMessages
• Remove unnecessary individual calls to fetch datasourceStorage and instead fetch all at once
• Cache plugins info

Creating a new task to handle these separately and closing this investigation task