Re: XML queries and Excessive Network Traffic

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 20 Jul 2014 18:51:34 -0700
Message-ID: <CAORjz=PgeUinQx+8QQV5zRwA8DoHD7Qe65q8KyDYKH=ro1MnDg_at_mail.gmail.com>

On Fri, Jul 18, 2014 at 2:56 PM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> So we can see that test with xmltypes has a little less roundtrips than
> clob, but In fifteen hundred times more than with varchar2

The tests I performed earlier (see first post) found the same thing.

The questions are:

1. why so much more traffic for the same data?
2. what can we do about it?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 21 2014 - 03:51:34 CEST