Radical difference in fetching records with clobs between PSD and SQL Developer - 11/01/18 01:55 PM
Hello
Subj
For example, a query to a table with clobs with 1000 rows executes in several minutes inside PSD but in several seconds inside SQL Devloper
OCI Debug shows that SQL Developer uses a method OCIStmtFetch with bulk collect whereas PSD doesn't use it
Thank you
Subj
For example, a query to a table with clobs with 1000 rows executes in several minutes inside PSD but in several seconds inside SQL Devloper
OCI Debug shows that SQL Developer uses a method OCIStmtFetch with bulk collect whereas PSD doesn't use it
Thank you