Hi, In one of our module we are using OQL query to fetch data from MSSQL database but here we are facing some slowness to fetch the data. We have already followed indexing attributes, still we are facing slowness. Is there any other way to improve query execution time or is there any 3rd party module for fetching data directly from MSSQL DB, kindly suggest any solution to improve our query execution time. Thanks & Regards.
You can call DB directly with SQL. Here is link to github and if you scroll down you will have examples how to use it.