Re: Help sizing for 2 Million a day (to 10 Million)

Posted in 1996

"Tom Hogarty" — 5 Jun 1996 20:53:23 -0400 — source: Informix-list mailing list archive (1991-1998)

> On Mar 12, 10:22am, Roger Meyers wrote: > Subject: Help sizing for 2 Million a day (to 10 Million) > Hi! > > I need to develop a solution that will support the processing of > 2 million transactions a day and be scalable to 10 million with no > major software modifications... > > The transactions are 256 bytes each. I can compute the disk > requirements, but what I don't have a feel for is how powerfull a > machine? They prefer some flavor of RS/6000. How did you measure the transactions ? How many tables involved ? Is the application on-line or batch ?, How many users will be active ? What kind of response time is acceptable to the customer ? Do you plan to log the transactions ? Do you intend to have mirroring active ? > To prepare for the 10 million should I develop differently of will > the scaleing all ocur in the Informix DBA area? Expected growth of the application is a vital part of your planning and development strategies, all other roads lead to pain and misery. > > Is anyone dealing with these types of numbers. Any pointers? The whole World is working on BIG numbers, think about government departments, banks, insurance companies, telephone companies. The numbers are getting bigger all the time. When the requirement is clearer, go to any hardware vendor(s) and wave the 'ol checkbook at them, say you need to see performance on their proposed hardware platforms/configurations and go for the one offering the best deal. > > TIA for any suggestions / information! > From my library I can offer the following reading suggestions... The Benchmark Handbook Jim Gray ISBN 1-55860-292-5 (Morgan Kaufmann Publishers) Transaction Processing: Concepts and techniques Jim Gray and Andreas Reuter ISBN 1-55860-190-2 (Morgan Kaufmann Publishers) The Art of Computer Systems Performance Analysis Raj Jain ISBN 0-471-50336-3 (Wiley Publishers) Hop This Helps, -- Tom Hogarty <Standard Disclaimers Apply> Performance Analyst Pyramid Technology Corp North First Street San Jose CA95164