Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Queries and Scalability


Database Queries and Scalability

Author
Message
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8247 Visits: 6122
Sometimes the problem is what the team have implemented.
Sometimes the problem is the team.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
lshanahan
lshanahan
SSC Veteran
SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)SSC Veteran (274 reputation)

Group: General Forum Members
Points: 274 Visits: 436
From the article:

Queries and joins are bad for your website performance. So is connecting to a database in the first place.

When I read this I thought of a quote a friend of mine made: "We put the 'DUH' in 'datacenter'." Kinda like the difference between (to borrow the author's waiter analogy) pulling leftovers from the fridge vs a full seven-course meal at an exclusive restaurant. "DUH", it's tons faster to pull from the fridge, but you might not want to eat it depending upon how long it's been there.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Miles Neale
Miles Neale
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2666 Visits: 1694
Gary Varga (10/22/2013)
Sometimes the problem is what the team have implemented.
Sometimes the problem is the team.


Gaz - Love it!

I led a project back in the 80's where I was the project manager and the team architect. We had a large number of people on board and due to a very tight timeline not everything got reviewed as it should by me and parts of the QA was delegated out to a senior developer. One of the dev staff wanted to do things an alternative way and in review the senior developer and I both said no. The developer went ahead on his own and developed it using the unapproved technology. Once his first major component was installed in the development environment we saw that the internals of the machine were showing a huge workload with a small number of transactions being active. Actually one system subroutine was running constantly consuming huge resource allotments.

When I investigated this in detail by reading believe it or not a huge internal core dump I was able to determine that the problem started and ended with the use of a self-defining data structure in an IBM CICS world. FYI this was mainframe PL/1. When I found this I called the developer in and we discussed the issue and got to the point where he admitted that he went ahead on his own initiative and did it his way even after being told no.

Sometimes the problem is the team!

Not all gray hairs are Dinosaurs!
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8247 Visits: 6122
The majority of the people I have worked with, worked for or have worked for me have been, at the very least, cooperative team players with reasonable communication skills. It has been a pleasure to know them and work with them but, unfortunately, there are always exceptions.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search