Talking about performance? How it will be... Example When user add finantial transaction into Docs table we must check balances of affected account in other table..
IB: After INSERT INTO, trigger fires and if balances don't allow execute transaction operation faile. No changes in data MSSQL: After INSERT INTO, write data into trasaction log, write data into table, fire AFTER trigger - oops! must undo operation - write data into trasaction log, delete data from table. What is better? I'm not talking about pages and records.... --- Alan Rose <[EMAIL PROTECTED]> wrote: > Speaking of axes boy do you sound like your got one > to grind. > Sounds to me like your just reading into everything > said literately, > just for the sake of an argument. > Purists don't impress me. Sometimes performance is > more important than > idealistic coding practices. > Its your way or no way is that right. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > Neven MacEwan > > Sent: Thursday, 1 June 2006 2:27 p.m. > > To: NZ Borland Developers Group - Delphi List > > Subject: Re: [DUG] Why InterBase > > > > Alan > > > > Clearly you have not implemented MSSQL or MSDE, > This sort of > > logic had some cost/functionality basis but as > MSDE is free > > its pretty much non sequitur, Why you would bother > to use > > three tools based on some archaic mantra is beyond > me, I > > would never bother with Access. > > > > You raise a couple of other issues > > > > > As for single user well take your pick. Don't > go over the > > top. MS >Access etc are fine. > > > > Do you also use a blunt axe if the wood is soft? > > > > > I reckon If you design your > > > tables right you should be able to avoid the > need for > > complex joins > anyway. > > > > Normalisation is bad? get real > > > > > A good design will avoid db corruption when > power lost etc. > > > > How? > > > > Cheers > > > > Neven > > > > > > > I would say MSQL and Oracle are ideal for > organisations who > > deal with > > > very large volumes, run mutli-processes > constantly and have > > an IT team > > > to support it (typically a DBA present). They > make use of the many > > > features that come with these heavy weights and > would use complex > > > joins etc a lot. E.g. Telecom and typically > large organisations in > > > heavy populated countries like US. > > > > > > > > > > IB or FB is a great choice for the next layer. > i.e. small to big > > > business. Ideal for most businesses typically > found in New Zealand. > > > Ideal for those without a DBA or simply just > don't need the extra > > > functionality as found in Oracle or MSSQL. I > reckon If you > > design your > > > tables right you should be able to avoid the > need for complex joins > > > anyway. This is where experience helps with > forward planning. J > > > > > > As for single user well take your pick. Don't go > over the top. MS > > > Access etc are fine. > > > With client side caching you could even handle 1 > to 3 users. If you > > > know your stuff. > > > > > > As for reliability a lot of it comes down to the > > > programmer. Keep it > > > simple. Know your database limitations, avoid > data-aware > > controls (i.e. > > > use client side caching, download only data that > you need for > > > performance). A good design will avoid db > corruption when > > power lost > > > etc. Make sure your clients understand the > importance of > > backups and > > > you should be able to sleep comfortably at > night. I know I do. > > > > > > _______________________________________________ > > > Delphi mailing list > > > [email protected] > > > http://ns3.123.co.nz/mailman/listinfo/delphi > > > > > > > > > > -- > > Neven MacEwan (B.E. E&E) > > Ph. 09 620 1356 Mob. 027 4749 062 > > > > New Address Details > > =================== > > MWK Computer Systems > > 1 Taumata Rd > > Sandringham > > Auckland > > > > Ph 620 1356 > > Fx 620 1336 > > > > _______________________________________________ > Delphi mailing list > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi > Edward Koryagin Send instant messages to your online friends http://au.messenger.yahoo.com _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
