Re: Definiitvely need sizing help

From: <bdbafh_at_gmail.com>
Date: 7 Apr 2005 08:39:59 -0700
Message-ID: <1112888399.821066.279820@l41g2000cwc.googlegroups.com>

pilot with a subset of data.

pay particular attention to refreshing of the DOMAIN indexes (text) as they are not maintained in a synchronous fashion. How much resources do those sync jobs take, and how "stale" of data can your app users tolerate?

you're storing all of the text in varchar2 inline in the main table? perhaps using CLOBs for the 3 text fields deserves consideration.

if the loads are batch, a refresh of the DOMAIN indexes after the load should suffice (e.g. daily).
if the loads are continuous ... you'll have to decide how frequently to sync the text indexes.

hth.

-bdbafh Received on Thu Apr 07 2005 - 10:39:59 CDT