how much do you have?
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Kornfeld Eliyahu Peter wrote:
(~23%)
We got you beat. 247 triggers on 741 tables, exactly 1/3, although not intentional.
There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Actually some of the triggers are there to log data changes (on important tables)... Others are for data integrity... And others are for sync with externals...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.
I have lived with several Zen masters - all of them were cats.
-
My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.
I have lived with several Zen masters - all of them were cats.
That sounds awful... Our triggers are short (sometimes 2-3 triggers on the same event, just because they all do something else)...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
That sounds awful... Our triggers are short (sometimes 2-3 triggers on the same event, just because they all do something else)...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
The major part of the application logic took place in those triggers. Guess why I run out of job interviews when I hear 'Access' or ' Former Acess project that has ben ported to xxx'.
I have lived with several Zen masters - all of them were cats.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
I've used 2 in my entire 32 years of doing this crap.
System.ItDidntWorkException: Something didn't work as expected. A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak -
My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.
I have lived with several Zen masters - all of them were cats.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Zero. Who needs 'em, eh?
-
Lotta time I see...
Caveat Emptor. "Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
Working on a review of the DB design to suggest improvements...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.
I have lived with several Zen masters - all of them were cats.
CodeWraith wrote:
My former bosses
Database guys in charge of application development? Sounds like it to me.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Zero. Though I may have written one about ten years ago. Only as a convenience for debugging. It was not vital to the system.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Surely that would affect performance to have that many? Most DBs I've worked on tend to not have more than a few tops.
Jeremy Falcon
-
CodeWraith wrote:
My former bosses
Database guys in charge of application development? Sounds like it to me.
Even worse. Access guys in charge. I must have offended him when I looked at that stuff and asked him what this particular form of insanity is called.
I have lived with several Zen masters - all of them were cats.
-
I found we use SQL triggers a bit too much... 336 triggers on 1450 tables... (~23%)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
:sigh: I hate triggers spit Development - 0 triggers UAT and Production 3 triggers on each of the master tables. I have a script that uses a configuration table to create and remove audit triggers on selected tables for each database. As we have approx 15 databases, any 3 of which will be deployed to production in any month this script is a life saver.
Never underestimate the power of human stupidity RAH
-
Working on a review of the DB design to suggest improvements...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
The major part of the application logic took place in those triggers. Guess why I run out of job interviews when I hear 'Access' or ' Former Acess project that has ben ported to xxx'.
I have lived with several Zen masters - all of them were cats.
Hey! I'm (still) working on an Access project ported to SQL Server. Don't knock it if you haven't tried it! Triggers are useful, but to embed business logic? Then even I would run away... 8)
-
Hey! I'm (still) working on an Access project ported to SQL Server. Don't knock it if you haven't tried it! Triggers are useful, but to embed business logic? Then even I would run away... 8)
It's the 'We don't need any architecture or documentation, and you are a fool for asking.' mentality that I don't like. They can keep on doing their stuff as long as they like (or until their customers finally have enough), but I will not work like that again.
I have lived with several Zen masters - all of them were cats.
-
It's the 'We don't need any architecture or documentation, and you are a fool for asking.' mentality that I don't like. They can keep on doing their stuff as long as they like (or until their customers finally have enough), but I will not work like that again.
I have lived with several Zen masters - all of them were cats.
Oh, indeed! Fortunately this project was written originally (entirely in Access) by someone who actually had a clue, and the 'owner' who understands the business (and is also a dev) has worked on it - so I have been able to gradually document the entire setup, what things represent and do etc. Whilst it's still very much a work in progress, I've been able to add all sorts of functionality, but I've discovered nearly 60 GOTCHAs (so far!) when moving from Jet to SQL - documented hereabouts somewhere. The trickiest new feature was CRM functionality as the data had to be imported from another (commercial) system where ALL information (used in tens, if hundreds) of different views was all stored in ONE huge SQL table and extracted by the most complicated series of inner joins and table aliases that I have ever seen. The person who wrote that must have been on acid! "Normalisation - never heard of it!" Definitely write only code...
