Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
SQL.Exec - inconsistent performance
Kris_Novi_(calgaryadmin_-_(deleted))
We are running into inconsistent performance of the SQL.EXEC statement. Straigth SQL executed in SQL Plus environment returns results in a split second, while executed via SQL.exec takes 6 sec, and from time to time may hit even 30sec. Are there any settings, connectivity issues or anything that may result in this performance degradation?
Find more posts tagged with
Comments
Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)
Start the SQL logging it so you get a feeliong when it happpens.Appended is something usefull I think in some magic language ;-))
Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)
Profiler in SQL server could also be nice if it is a SQL server ;-))