Re: HELP : S.E (7.x) nearly faster than OWS (7.x)
Bryan Tonnet wrote: > > In <a6tTyKAlmwD1Ew1R@smooth1.demon.co.uk> David Williams <djw@smooth1.demon.co.uk> writes: > > > I HATE AND LOATHE SE, I'VE LOST AR LEAST 5 NIGHT UP TO 1AM OF MY OWN > > ^^^ > > > TIME, UNPAID JUST BECAUSE SE CAN't ROLLBACK UNCOMMITED TRANSACTIONS > > ^^^^ ^^^^^^ > > > WHEN IT STARTS.. HEAP OF SH*T!!! > > > Sorry but that is just how I feel. The sooner we get our sites onto > > Online 7.23 on Sun boxes running Solaris 2.5.1/2.6 the happier I will > > be. > > Those are, of course, your feelings and I wouldn't want to contradict them, > but just to counterpoint the annecdotal evidence, the 2 mid sized SE sites > I support (1Gb Db, largest table .5Mil rows), have had no DB related problems > for over 2 years. I've only ever run [b|se]check on one of them, once, and > that was only for interest's sake. > > All of David's technical points are very valid (SE can only roll forward > , locks in transactions behave differently (and in less logical manner) > than Online/DSA etc), but for small-middle level apps, with 10-40 users and > no great table size, SE *is* a fast, simple and stable alternative. You > just have to weigh up the risks, same as any business decision. > > > > > >-- > >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 > -- > Bryan Tonnet > batonnet@phase4.com.au In a small SE installation but with complex table relationships I used to have two tables that got corrupted indexes regularly on version 4.0. On version 7.10 and 7.12 the problem has disappeared. I do an overnight bcheck on every table every weekend and mail myself any problems. I haven't had any. (It also does an index reclustering - after the check, of course.) Then my hardware and OS is rock solid... Oh, and I don't let the users near the Unix command line. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/