Good afternoon. I use the Connect Storage Engine to connect the MariaDB database to Oracle using ODBC.
There was one problem, or it's just a feature of the connection, namely the Oracle database has a lot of tables, and for convenience.
I created Views that makes a selection of many tables. This view produces about 400 000 rows as a result, and a query without a filter
is processed for about 7 seconds. If I add additional filter type
this query would run about 300-500 milliseconds.
All fast enough.
Next, I create a connection through the Connect Engine, such as this
And when I'm on the side already MariaDB trying to make a query
Then the query is executed about 30 seconds, if I add the same filter, the result is the same
The feeling that MariaDB connects to Oracle, and at first simply takes absolutely all result, i.e. it does not transfer the Oracle request (i.e. does not ask to filter it), and when to it Oracle gives all result (i.e. all 400 000 lines) only then already MariaDB on the party begins to filter on my requirements.
The question is, if this is how it works, is it possible to delegate the selection to Oracle? So that MariaDB has already come to the finished result
It seems in the documentation that something like this was written, but my English is not very good, and there is no doubt