Re: Need for Speed...
Hi Gurus,
First of all thanks for the response.
>
> Here are the stats....
>
>
>-------------------------------------------------------------
>ROWS SIZE
>TABLE1 - 629649
>TABLE2 - 487323
>TABLE3 - 631455
>
>-------------------------------------------------------------
>onstat -c>
>Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 03:35:05 -- 1018936
> Kbytes
>
>Configuration File: /u5/informix/etc/onconfig
>#**************************************************************************
>#
># INFORMIX SOFTWARE, INC.
>#
># Title: onconfig
># Description: Informix Dynamic Server Configuration Parameters
>#
>#**************************************************************************
>
># Root Dbspace Configuration
>
>ROOTNAME root1db # Root dbspace name
>ROOTPATH /dev/infbroot # Path for device containing root dbspace
>ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
>ROOTSIZE 2000000 # Size of root dbspace (Kbytes)>
># Disk Mirroring Configuration Parameters
>
>MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
>MIRRORPATH # Path for device containing mirrored root
>MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
># Physical Log Configuration
>
>PHYSDBS root1db # Location (dbspace) of physical log
>PHYSFILE 50000 # Physical log file size (Kbytes)>
># Logical Log Configuration
>
>LOGFILES 40 # Number of logical log files
>LOGSIZE 8192 # Logical log size (Kbytes)>
># Diagnostics
>
>MSGPATH /u5/informix/log/palawan1.log # System message log file path
>CONSOLE /dev/console # System console message path
>ALARMPROGRAM /u5/informix/etc/log_full.sh # Alarm program path>SYSALARMPROGRAM /u5/informix/etc/evidence.sh # System Alarm program path
>TBLSPACE_STATS 1>
># System Archive Tape Device
>
>#TAPEDEV /dev/null # Tape device path
>TAPEDEV /dev/rmt/1m # Tape device path
>TAPEBLK 16 # Tape block size (Kbytes)
>TAPESIZE 24000000 # Maximum amount of data to put on tape (Kbytes)>
># Log Archive Tape Device
>
>LTAPEDEV /dev/rmt/2m # Log tape device path
>LTAPEBLK 16 # Log tape block size (Kbytes)
>LTAPESIZE 24000000 # Max amount of data to put on log tape (Kbytes)>
># Optical
>
>STAGEBLOB # Informix Dynamic Server/Optical staging area
>
># System Configuration
>
>SERVERNUM 1 # Unique id corresponding to a Dynamic Server in>stance
>DBSERVERNAME jose1tcp # Name of default database server
>DBSERVERALIASES jose1ipc # List of alternate dbservernames
>NETTYPE ipcshm,2,70,NET # Configure poll thread(s) for nettype
>NETTYPE soctcp,9,70,NET # Configure poll thread(s) for nettype
>DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
>RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
>
>MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
>NUMCPUVPS 3 # Number of user (cpu) vps
>SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
>
>NOAGE 1 # Process aging
>AFF_SPROC 0 # Affinity start processor
>AFF_NPROCS 0 # Affinity number of processors>
># Shared Memory Parameters
>
>LOCKS 200000 # Maximum number of locks
>BUFFERS 50000 # Maximum number of shared buffers
>NUMAIOVPS 12 # Number of IO vps
>PHYSBUFF 128 # Physical log buffer size (Kbytes)
>LOGBUFF 128 # Logical log buffer size (Kbytes)>LOGSMAX 100 # Maximum number of logical log files
>CLEANERS 33 # Number of buffer cleaner processes
>SHMBASE 0x0 # Shared memory base address
>SHMVIRTSIZE 900000 # initial virtual shared memory segment size
>SHMADD 32000 # Size of new shared memory segments (Kbytes)
>SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
>CKPTINTVL 3000 # Check point interval (in sec)
>LRUS 65 # Number of LRU queues
>LRU_MAX_DIRTY 80 # LRU percent dirty begin cleaning limit
>LRU_MIN_DIRTY 70 # LRU percent dirty end cleaning limit
>LTXHWM 50 # Long transaction high water mark percentage
>LTXEHWM 60 # Long transaction high water mark (exclusive)
>TXTIMEOUT 0x12c # Transaction timeout (in sec)
>STACKSIZE 32 # Stack size (Kbytes)>
># System Page Size
># BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
># To determine the page size used by Dynamic Server on your platform
># see the last line of output from the command, 'onstat -b'.
>
>
># Recovery Variables
># OFF_RECVRY_THREADS:
># Number of parallel worker threads during fast recovery or an offline restore.
># ON_RECVRY_THREADS:
># Number of parallel worker threads during an online restore.
>OFF_RECVRY_THREADS 10 # Default number of offline worker threads
>ON_RECVRY_THREADS 1 # Default number of online worker threads>
># Data Replication Variables
># DRAUTO: 0 manual, 1 retain type, 2 reverse type
>DRAUTO 0 # DR automatic switchover
>DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
>DRTIMEOUT 30 # DR network timeout (in sec)>DRLOSTFOUND /u5/informix/etc/dr.lostfound # DR lost+found file path
>
># CDR Variables
>CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
>CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
>CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
>CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kb
>ytes)>
># Backup/Restore variables
>BAR_ACT_LOG /tmp/bar_act.log
>BAR_MAX_BACKUP 0
>BAR_RETRY 1
>BAR_NB_XPORT_COUNT 10
>BAR_XFER_BUF_SIZE 31>
># Informix Storage Manager variables
>ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to
> # update $INFORMIXDIR/bin/onbar. Change to
> # ism_catalog -create_bootstrap -pool <new name>
>ISM_LOG_POOL ISMLogs
>
># Read Ahead Variables
>RA_PAGES 128 # Number of pages to attempt to read ahead
>RA_THRESHOLD 120 # Number of pages left before next group>
># DBSPACETEMP:
># Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
># that the Dynamic Server SQL Engine will use to create temp tables etc.
># If specified it must be a colon separated list of dbspaces that exist
># when the Dynamic Server system is brought onl
The query, query plan and schema for the tables would be good too (including fragmentation strategy) Will Sent via Deja.com http://www.deja.com/ Before you buy.