fsa3_at_optonline.net wrote:
> It is Oracle 9i. Stats are current and yes their is a unique index on
> the mytablekey. The blob is a large piece of xml generated by the
> application.
>
> After more conversations and analysis it seems to be a disk I/O issue.
> One thing I'm considering is to move this table into its own
> tablespace. I've read that tables with blobs that are heavily accessed
> may want to have their own block size. Now, I'm trying to figure out
> the right way to determine what that block size is.
>
> Thanks!
Makes sense ... but I would argue that storing XML is a bad idea. What
you are doing is reading and writing a lot of bytes to do what could
easily be done in memory from relational data: Thus the i/o issue.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Nov 18 2005 - 13:11:07 CST
