when I run a “simple” query, DOING SCIENCE taking a long time until in the main tables I created it
You have to provide much more details. There’s probably 5-10 more things, but let’s start with this:
Which version of Metabase? What metadata database are you using?
Which database are you querying? Is it local or remote?
What’s the load of Metabase and the database?
thanks for your time! I checked the number of users in Metabase, the number was 12 users. I deactivated most of their accounts then restarted the server and increased the ram capacity. the result was good and my queries are so fast.