A common complaint of the Entity Framework is slow insert times for larger datasets. Last night I was trying to insert a catalog of 15k products and it was taking a very long time (I gave up after 5 minutes). I recalled this post a while back from Mikael Eliasson demonstrating SqlBulkCopy using .NET. I […]
Read MoreEarlier this week I ran into a little quirk with SQLite. Take a look at the following code snippet: using(var transaction = new TransactionScope(TransactionScopeOption.Required)) { using(var connection1 = new SQLiteConnection(_connectionString)) { connection1.Open(); … // Do stuff with the open connection } // Closes the connection (so we think …) using(var connection2 = new SQLiteConnection(_connectionString)) { […]
Read MoreGiven: One Windows Service, written in C#, using SQL Reporting Services via the SSRS web services. MyApp.Service waits for work requests to come in, and when it finds them it uses SSRS to generate some PDFs (among a bunch of other stuff). The Windows Service code is in one project, “myapp.service,” and the code that […]
Read MoreSeeing as how I have not graced these pages with my presence in quite some time. I figured I better get something going. A little while back my team started working with some outside contractors and our make shift way of keeping changes in sync and under control was simply not cutting the mustard. Why […]
Read MoreNOTE: this is the same post from a week ago, but now I added in performance times from actual devices. 1. Palm Treo 750 (300 Mhz) 2. Palm Treo Pro (600 Mhz) 3. HP iPAQ hw6945 (416 Mhz) – oldest device First change for the previous listings: cpu is not everything. The iPAQ has a […]
Read MoreI posted on this about a year ago. I am reposting this as a Public Service Announcement (otherwise known as a PSA). Do you have a stored procedure where the amount of data returned can vary wildly depending on what parameters are passed in? Does performance change dramatically depending on how much data is being […]
Read MoreHi it’s Jason again. I enjoyed writing my last post on SQL pivot so much that today I thought that I would explore another rarely used feature of this ubiquitous query language – the window clause. As before I am using SQL Anywhere 10 but the same technique will work with several modern databases such […]
Read MoreThis is Jason who is continuing to masquerade as a guest. I’m going to let you into a dirty little secret…I’ve written a lot of SQL during my career. This admission almost sounds like heresay in these days of DDD, BDD etc. but it’s still an incredibly useful skill to have. Anyway a lot of […]
Read More
Recent Comments