Creating a SQLDatabase query engine takes too long:
This single line
sql_database = SQLDatabase(engine)
Takes minutes to connect to the database and create the engine. Inspecting the python library I found that this function call
self._metadata.reflect(
views=view_support,
bind=self._engine,
only=list(self._usable_tables),
schema=self._schema,
)Is the thing that takes so much time, and erasing it does in fact reduce time to less than 5 seconds.
What does this do??? Is it neccesary???
Also i wanted to know if there is an async way of creating this engine, i did'nt find anything in docs
