Re: 50M+ queries

Posted in 2000

Obnoxio The Clown — Wed, 19 Jul 2000 10:28:28 BST — source: Informix-list mailing list archive (1991-1998)

From: Daniel Wood <dwood@informix.com> > >Were you running with an shm connection? No. >At 5 copies, if you were going acrossed the net, you would be exceeding >30MB/sec Both client and server were on the same box. >which even a 100 base-T couldn't handle. 50MB * 240bytes / 409secs > >I've run similar tests with smaller row sizes(36) and smaller tables (65536 >rows). >On a 10 processor(9 CPU VPs) 250MHZ Sun box I've sustained 12000 selects >per >second, 43 million per hour. On a 24 processor(16 CPU VPs) 250 MHZ Sun box >I've done 16000 selects per second, ~58 million per hour. This was over a >100 >base-T >network. > >Given this figures I suspect a newer Sun box with 10 to 16 CPUs at 400 MHZ >should >meet his needs. If there are a lot of users you should certainly consider >MaxConnect. >And a fast network. All perfectly valid, random words. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com