11.4 Sql Performance Issue

Posted by Karikalan Ram on 15-Nov-2016 10:48

Hi everyone,

I've 11.4 OE with ODBC setup to access SQL server 2012 located at the remote server and Sql Server Native client in my local system. I'm experiencing very poor performance of running a query or retrieving records with this environment setup as it taking hell amount time to bring the records to front end - whereas same code logic works well in OE 10.2B with Openedge local database. I'm sure no issues or no space to optimize the code. Is there any way for performance tuning or check-points I should consider to improve 11.4 OE Sql environment performance? 
Thanks.
Kalan.

All Replies

This thread is closed