Re: Stretching the limits of SE
} Subject: Stretching the limits of SE } Date: 7 Dec 1994 19:50:42 GMT } Reply-To: smorrow@dotrisc.cfr.usf.edu (Stephen Morrow) } Organization: University of South Florida } } Hi folks, } } I'm curious to know how far some of you SE users are pushing your engines } (especially concerning the number of users). } } We are currently running SE 5.0 on AIX w/ a 32-user license, with an } unlimited license probably coming around in the near future. Our } departmental processor (which currently maintains internal applications) } is going to change to a university-wide processor thanks to a new } purchasing system which will be available to a few thousand employees (who } will sign on only if they need to requisition something). Also, future } applications are planned for in the future. } } Of course, I'm trying to talk the powers-that-be into going w/ Online. } } Anyway, I'd really like to hear some words of wisdom/encouragement, horror } stories, or whatever, so I know what I could possibly expect with our } good 'ol SE :-) } } Again, current specs are: } SE 5.0 (w/ 3 DB's, 300+ tables, 320+MB in size) } AIX 3.2.1 (but upgrading to 3.2.5, w/ unlimited users) } ISQL 4.1 } I4GL 4.1 } } Thanks for your time & cooperation... } } Steve Morrow, Sr. Programmer/Analyst } University of South Florida In an older system, since replaced by an Oracle installation which is almost as good, we had: SE 2.10 (I said it was older!) (1 DB, 90 tables, 100,000+ rows in several, don't recall total MB) Sun 690 running SunOS 4.1.3 I4GL 1.10 (don't laugh!) application running on 120+ workstations, mostly Sun SparcStations, but a few DOS boxes The application was designed to disconnect from the database when the user was doing other things, like CAD drawing, etc. Because of this, the maximum concurrent users actually connected seldom rose above the teens. The workstations were on a network stretching from Cape Canaveral in Florida to Vandenburg AFB in California, with the DB engine in Denver. Response time was almost always satisfactory, except for occasional long-line problems when ALL communications were suffering. Except for the total Mbytes, which I don't remember, the DB was about one third the size of your 3 DBs; so it is somewhat comparable. My guess is that any choke point you find will be in the central computer's capacity and/or AIX, not in the DB engine. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\