Optimize Backend

[elena-krismer]

• refactor code
• Async Operations: Ensure that all asynchronous operations are efficiently managed. Use Promise.all() where possible to run parallel queries that don’t depend on each other, reducing wait times.
• Caching: ICaching: Implement caching for data that doesn't change often, such as taxonomy names or other static lookup data. This can reduce database load and improve response times.
• Validation: Move Joi validation to middleware to clean up the controller functions and centralize validation logic.
• Denormalization: Consider if denormalization makes sense for any of your tables. This can reduce the complexity of joins but at the cost of increased storage and potential complexities in data consistenc
• query optimization
• Batch Inserts/Updates: If operations involve multiple insert/update queries, consider batching these operations to minimize the number of database hits.