Re: Anyone using SE with high transaction volume?

In article <70a90r$pd7$1@nw001t.infi.net>, The Wilcoxons <wilcoxon@pione erplanet.infi.net> writes > >Jacob Salomon wrote in message <36275BE0.632608AB@garpac.com>... >>Hi Family. >> >>One of my managers (a short dumpy guy with pointy hair around an >>otherwise bald head ;-) asked for references about this. >> >>Does anyone here use SE with a high volume of trasactions? Handling 40+ >>users? What kind of performance do you get? >> >>I tried looking for this in DenaNews and noted that someone (Mariusz M) >>had run benchmarks for SE. But we need info on real world performance of >>applications using Standard Engine. Prefereably 7.2+ of SE. > > >I had experiences with an older version of SE before we moved to IDS. It was >very solid, but would tend to require a faster system then IDS does for the >same number of users & transaction work. I think just the reduction in I/O >overhead from VARCHAR's and raw disk I/O alone make IDS pay for itself (we >have some tables with LOTS of VARCHAR's that are only 10%-15% full - really >cut down on I/O and increases cache hit rate!). > >S.W. > Lots of our customers run SE. It is ok for up to 50 users and up to 2Gb of data. The main problems are:- a) Uses buffered I/O hence we lose transactions if UNIX fails. b) Does NOT rollback imcomplete transactions after UNIX failure. c) Cannot backup whilst people are using the system. d) Transaction log MUST be truncated IMMEDIATELY after the backup is done. This never seems to work for us and we always fail to rollforward. Online has all of these feature and can log to tape which is much better. >>Thanks. >>-- > >I got rid of my tie because of the curls. >>+------------------------------------------------------------+ >>| The expedient performance of a task with excessive concern | >>| regarding its durion-to-completion engenders a virtual | >>| certainty of diminished benefit therefrom. | >>| -- Benjamin Franklin (but he said it in 3 words) | >>+------------------------------------------------------------+ > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care