Blobs and Performance

Posted in 1997

Topics: Performance & Tuning, Storage & Space Management

Anthony Pierre — 4 Jun 1997 15:23:10 -0400 — source: Informix-list mailing list archive (1991-1998)

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. ? Are two reads required when blobs are stored in blobspaces apart from = data? 2. Other than access to the source code, which we do not have, are = there any items that can be modified to improve performance.? 3. Are there any fixed method to determine what item (memory,disk) of = the system is causing the performance hits.=20 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

Glossary

blobspace