Problems with big queries

Hello, I'm experiencing some issues with my queries (sql). We have large queries involving joins and filters (including date filters, and we also map some fields). We then render these queries in visualizations on various dashboards. The problem is that we sometimes encounter errors because they take too much time. Could you please provide some advice on how to improve our queries for metabase or ways to deal with big queries?