Re: Looks Like The Party Is Over In Menlo (2nd try)

From: "smooth1" <smooth1@iclway.co.uk> > >David Stes wrote in message <3996D0C7.4F8BF4C0@pandora.be>... > >smooth1 wrote: > >> > >> - 9.20 and soon 9.30 will merge the 2 engines. > >> - Workgroup Edition appeared at 1/3 the price to replace SE. > > > >Why exactly is it that SE has to be replaced ? > > 1. No logical recovery:- > > After a crash or if a sqlexec process > (i.e. session) dies uncleanly or is killed you have to > > a) bcheck the whole database > b) in an index has one corrupt entry, rebuild the whole index > rather than rollingback the transaction. > > 2. No checks on the data. > > IDS has page header/trailer timestamps and does consistency > checking on each page accessed. (Hence Assert Failed > messages). > > 3. No way to backup with the users on. > > Hence most sites get at least minor inconsistencies in their > backups. > > 4. No way to cleanly kill a process (IDS has onmode -z to cleanly > kill a session). > > > Hence, my backups are corrupt, I can't handle crashes, kill errant > users and I won't know about corruption until someone spots > that the system is producing crap data (if this gets spotted at all!). > > SE is out of data in terms of data integrity and should be dropped > in favour of IDS Workgroup Edition. That's all fine and dandy, David, but what about small sites who can't afford a DBA and just want a simple database platform? Shall we just hand them over to Access, where they can grow into SQL Server? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Obnoxio The Clown wrote in message <8n8ddm$8g6$1@news.xmission.com>... >> Hence, my backups are corrupt, I can't handle crashes, kill errant >> users and I won't know about corruption until someone spots >> that the system is producing crap data (if this gets spotted at all!). >> >> SE is out of data in terms of data integrity and should be dropped >> in favour of IDS Workgroup Edition. > >That's all fine and dandy, David, but what about small sites who can't >afford a DBA and just want a simple database platform? > Why does online need a DBA? You can automate start and shutdown automate backups with onbar and ISM. If online panics then that is only to stop data corruption. Are you saying it is ok for your customer to have undetected corrupt data? Please let me know the names of the customer for whom this is ok and I'll pass onto them the good news. >Shall we just hand them over to Access, where they can grow into SQL Server? > > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >