I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...
A typical screen in your user interface probably combines data from several different tables. To handle that, I typically have my back-end processes generate Data Transfer Objects (DTOs) which combine ...
Now that you understand the basic structure of a SQL application, let's dissect the basis of information retrieval: the query. For many techies, especially those that focus on systems administration, ...
I'm only a programmer by necessity (unix sysadmin). Far more of my time is spent taking apart other people's code than putting things together from scratch. This is nice as far as seeing how others do ...