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

Entire Thread
Subject	Posted By	Posted
Radical difference in fetching records with clobs between PSD and SQL Developer	Albert	11/01/18 01:55 PM
Re: Radical difference in fetching records with clobs between PSD and SQL Developer	Marco Kalter	11/02/18 10:09 AM

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.111s Queries: 14 (0.089s) Memory: 2.5249 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-20 13:23:54 UTC
Valid HTML 5 and Valid CSS