Re: SE 7.24 performance

From: "r_hao" <r_hao@hotmail.com> > >We have a table with about 14 million records. This table was part of >database running on Linux machine(SE 7.2 too). Since you got a better HP >UNIX (10.2) machine, we moved it to HP UNIX. However, the performance of >SELECT sql (we only do the 'select' in day-time and 'insert' in night-time) >against that table is worse then when it was on the Linux. I have updated >STATISTICS, and created many index and alter major index to CLUSTER index, >the performance seem to be the same. What others I can do for it. Move back to the Linux box? I did a benchmark once, between an HP G50 running HPUX 9.x and a Pentium 90 running Unixware (man, that was a long time ago... :-) and I was utterly gobsmacked when the Pentium beat the HP in every single test up to 100 users. At that point, the HP fell over. Of course, the HP was an entry level and the Pentium was hotted up to the max, but still... Unless your HP is *much* better than entry level, I wouldn't assume it's faster. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.