It is known that instantiating ActiveRecord objects is slow. When querying, most of the time it's necessary to instantiate them so we can invoke their methods or navigate their relationships. When you need to do a custom select with a...

Today I was profiling an application. The timings pointed to a piece of code that executed a query using LINQ. I opened an SQL profiler and saw what queries were performed. Here they are: SELECT [t3].[value] AS [Key] FROM ( SELECT ( SELECT [t2].[Role...

I had to fix a problem in a Silverlight application we are building. The problem was that it's CPU usage was constant, between %20 and %40, and never stopped. I won't go into the details of how I discovered the problem, but I'll tell you what the problem...