Browse by Tags

• performance

Linq Compiled Queries Q & A
25 August 08 12:21 PM | ricom | 5 Comments   

I did a series of postings on Linq Compiled Queries last year, I recently got some questions on those postings that I thought would be of general interest. Q1: Why use the 'new' keyword in this snippet? var q = from o in nw.Orders select new {o.everything Read More...

Filed under: performance, design advice, databases

Database Performance, Correctness, Compostion, Compromise, and Linq too
31 August 07 06:10 PM | ricom | 16 Comments   

Introduction and Disclaimer Regular readers of my blog are already familiar with my goal to provide brief and useful information that is approximately correct and that illustrates some key truths. Most of the time my articles are not authoritative and Read More...

Filed under: performance, design advice, databases

Caching Redux
25 June 07 08:47 AM | ricom | 0 Comments   

I got some interesting questions about how to build good middle-tier caches in my inbox last week. I cleaned up the responses a little bit and I'm posting them here because they're actually pretty general. I've written about this before but some things Read More...

Filed under: performance, design advice, databases

Optimistic vs. Pessimistic Locking consequences
24 June 04 12:39 PM | ricom | 2 Comments   

Putting on my "database guy" hat, a few days I was asked to comment on locking techniques for databases and to point out some problems with using transactions as a pessimistic locking technique. Here's what I said... Some definitions: Optimistic locking Read More...

Filed under: design advice, databases

Some thoughts/advice about databases and caching
10 May 04 12:57 PM | ricom | 3 Comments   

As usual, kindly allow me to speak in rough terms so that I might be brief keeping in mind that there are exceptions to what I write below. I think the most important thing to remember about serving data from a database is that, as a practical matter, Read More...

Filed under: performance, design advice, databases