Radical difference in fetching records with clobs between PSD and SQL Developer - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Radical difference in fetching records with clobs between PSD and SQL Developer

Print Thread

Radical difference in fetching records with clobs between PSD and SQL Developer #58758 11/01/18 01:55 PM
Joined: Jun 2003 Posts: 71 Russia A Albert OP Member
OP Albert Member A Joined: Jun 2003 Posts: 71 Russia	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 Last edited by Albert; 11/01/18 04:27 PM. There are 10 types of people: those who know binary and those who don't

Re: Radical difference in fetching records with clobs between PSD and SQL Developer Albert #58768 11/02/18 10:09 AM
Joined: Aug 1999 Posts: 22,214 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,214	We'll see if we can enhance this. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.062s Queries: 15 (0.030s) Memory: 2.4953 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 05:59:07 UTC
Valid HTML 5 and Valid CSS