Re: LOBs performance

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Thu, 15 Jun 2000 19:26:09 +0200
Message-Id: <10529.109437@fatcity.com>

On Thu, Jun 15, 2000 at 08:14:15AM -0800, Andrey Bronfin wrote:
> Dear all !
>
> I have a question for those of U who works with LOBs :
> Do U have any tips / techniques / experiences for optimizing performance of storing & retrieval of CLOBS ?

Currently I have about 200000 XML documents in a table. They are stored in a VARCHAR2/CLOB col - depending on their size. I can extract parts from the document with a stored procedure in Java. So I can process about 500 documents/second e.g. for building a hit list from a full text search....and the code far away from being called "production code".

Fast enough ? Received on Thu Jun 15 2000 - 12:26:09 CDT