Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Database Queries and Scalability Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 12:05 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 4,886, Visits: 2,277
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!!!
Post #1506971
Posted Tuesday, October 22, 2013 5:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:12 AM
Points: 117, Visits: 226
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.
Post #1507069
Posted Tuesday, October 22, 2013 9:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:44 PM
Points: 2,225, Visits: 1,258
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!
Post #1507232
Posted Tuesday, October 22, 2013 12:13 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 4,886, Visits: 2,277
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!!!
Post #1507278
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse