Re: New server...
From: "Patricio Riveroll" <priveroll@grupositel.com.mx>
>
>I will be installing a new box next week, It's a Sun 3500 with 4 cpu's, 2
>Gb
>mem, solaris 5.6 and Informix Dynamic server 7.31.UC4.
>Planned to handle 450 concurrent users, the databse will be unbuffered and
>most of the transactions will be inserts with few updates.
>Database conformed with up to 10 tables, 16 fields each (numeric), 15000
>rows each.
>There will be running queries each 15-30 seconds, so the performance is an
>isue.
>
>Any advice in how to get the most performance will be appreciated.
It depends.
But because I've been nasty to everyone else today, I'll be nice to you and
give you the wrong advice:
1. UPDATE STATISTICS
2. Judicious indexing
3. In your onconfig:
BUFFERS 768000
LRU_MAX_DIRTY 2
LRU_MIN_DIRTY 1
LRUS 127
CLEANERS 127
MULTIPROCESSOR 1
SINGLE_CPU_VP 0
NUMCPUVPS 4
TBLSPACE_STATS 0
OPTCOMPIND 0
4. Make sure data is spread out across disks.
5. At least 3 temp dbspaces, all on their own spindles.
6. Physical and logical logs on their own, separate spindles.
7. NO RAID5 NO RAID5 NO RAID5 NO RAID5 NO RAID5 NO RAID5
For a start.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com