Need to improve OQL query execution time

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.
1 answers

Hey Ramakrishna,


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.