Re: Blobs and Performance
In article <5n4fau$rs@cssun.mathcs.emory.edu>, Anthony Pierre
<apierre@petrotrin.com> writes
>The configuration of the machine and database is given below. We have an =
>application whose performance is unacceptable. The tables are evenly =
>spread over=20
>
>Questions=20
>1. Does the use of blobs in blobspaces affect the performance of =
>ONLINE. ?
Yes.
> Are two reads required when blobs are stored in blobspaces apart from =
>data?
Yes.
>2. Other than access to the source code, which we do not have, are =
>there any items that can be modified to improve performance.?
Yes. All the parameters in the ONCONFIG file and the UNIX kernel.
>3. Are there any fixed method to determine what item (memory,disk) of =
>the system is causing the performance hits.=20
Yes, send me an onstat -a and I'll take you through them.
>problems exist and some The tables are evenly spread over the disk =
>drives. to look to We do not=20
>
>We are currently running
>DEC 2100 Digital UNIX 3.0B=20
>5 X2GB disk drives 640 RAM
>INFORMIX 5.03UC3 engine.=20
>Some configuration parameters
>
>BUFFERS 25000
>
>PHYSBUFF 1024
>LOGBUFF 32
>CLEANERS 4
>LRUS 8
>LRU_MAX_DIRTY 5
>LRU_MIN_DIRTY 3
>LTXHWM 50
>LTXEHWM 60>
>TIA
>ANTHONY e PIERRE email apierre@petrotrin.com
>
>
>
--
David Williams