Worst app ever!
-
I've worked at places where they believed that the database should do as little of the work as possible too. X|
PIEBALDconsult wrote:
I've worked at places where they believed that the database should do as little of the work as possible too.
Yip, me too, funny the DBA agreed with the issues, but said there was not enough time to do all the 'optimizations'. He had been working a good few years on that DB...
xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008) -
I just started at a new place and came on to to help with their database and application stuff. I knew it was bad as soon as I saw their databases. For example they have an article table and a column called ArticleTopics which has "23,5,45,78,23,.." they where pulling it into the app normalizing it and getting all topics which of course had TopicCategories "34,56,..." and such. Not a join could be done in the whole database. I normalized the database using SSIS script component and rewrote the app from coldfusion to ASP. Finally I submit a request to shut down the old system do one last pull of the data in SSIS and register the new app with the domain and this admin comes to my office screaming that I should never use foreign keys and all normalization should be done in the app because they cause performance problems and that asp is crap, I should use dhtml. I couldn't believe it when my boss told me I need to rewrite it. I lost it. Anyway anyone need a good DBA/OLAP Designer?
Much sympathy - obviously the admin is useless and feels threatened. Hope you find a new position soon!
'Howard
-
I just started at a new place and came on to to help with their database and application stuff. I knew it was bad as soon as I saw their databases. For example they have an article table and a column called ArticleTopics which has "23,5,45,78,23,.." they where pulling it into the app normalizing it and getting all topics which of course had TopicCategories "34,56,..." and such. Not a join could be done in the whole database. I normalized the database using SSIS script component and rewrote the app from coldfusion to ASP. Finally I submit a request to shut down the old system do one last pull of the data in SSIS and register the new app with the domain and this admin comes to my office screaming that I should never use foreign keys and all normalization should be done in the app because they cause performance problems and that asp is crap, I should use dhtml. I couldn't believe it when my boss told me I need to rewrite it. I lost it. Anyway anyone need a good DBA/OLAP Designer?
What a start! Too bad, that sounds like some crap. When I apply for a job next time I will ask to see samples of their code. Or at least ask them about their coding standards etc.
_____________________________________ Action without thought is not action Action without emotion is not life
-
What a start! Too bad, that sounds like some crap. When I apply for a job next time I will ask to see samples of their code. Or at least ask them about their coding standards etc.
_____________________________________ Action without thought is not action Action without emotion is not life
-
PIEBALDconsult wrote:
I've worked at places where they believed that the database should do as little of the work as possible too.
Yip, me too, funny the DBA agreed with the issues, but said there was not enough time to do all the 'optimizations'. He had been working a good few years on that DB...
xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)"If you don't have time to do it right, when will you have time to do it over?"
-
I just started at a new place and came on to to help with their database and application stuff. I knew it was bad as soon as I saw their databases. For example they have an article table and a column called ArticleTopics which has "23,5,45,78,23,.." they where pulling it into the app normalizing it and getting all topics which of course had TopicCategories "34,56,..." and such. Not a join could be done in the whole database. I normalized the database using SSIS script component and rewrote the app from coldfusion to ASP. Finally I submit a request to shut down the old system do one last pull of the data in SSIS and register the new app with the domain and this admin comes to my office screaming that I should never use foreign keys and all normalization should be done in the app because they cause performance problems and that asp is crap, I should use dhtml. I couldn't believe it when my boss told me I need to rewrite it. I lost it. Anyway anyone need a good DBA/OLAP Designer?
I woulda quit on the spot.
-
I woulda quit on the spot.
-
While quitting on the spot does sound appropriate many have obligations to family/creditors that don't allow that luxury. Still, I would move on as soon as reasonably possible.
I suppose. I have kids and creditors and the possibility would arise very quickly.
-
I just started at a new place and came on to to help with their database and application stuff. I knew it was bad as soon as I saw their databases. For example they have an article table and a column called ArticleTopics which has "23,5,45,78,23,.." they where pulling it into the app normalizing it and getting all topics which of course had TopicCategories "34,56,..." and such. Not a join could be done in the whole database. I normalized the database using SSIS script component and rewrote the app from coldfusion to ASP. Finally I submit a request to shut down the old system do one last pull of the data in SSIS and register the new app with the domain and this admin comes to my office screaming that I should never use foreign keys and all normalization should be done in the app because they cause performance problems and that asp is crap, I should use dhtml. I couldn't believe it when my boss told me I need to rewrite it. I lost it. Anyway anyone need a good DBA/OLAP Designer?
The admin sounds like he has issue, coming in and screaming like that. Geeze.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
"If you don't have time to do it right, when will you have time to do it over?"
After the demo? :laugh:
-
After the demo? :laugh:
No, after the demo the customer has a bunch of new features they need.
-
After the demo? :laugh:
You laugh, but this was the policy (and still is) of my last place of employment... :wtf:
-
You laugh, but this was the policy (and still is) of my last place of employment... :wtf:
Only there? :omg: