3 ms·
> My several years old laptop does this with the most straight forward C# implementation in 170 ms. Sure, but writing a custom C# program for each query on dat
by defen 9y ago
> My several years old laptop does this with the most straight forward C# implementation in 170 ms.
Sure, but writing a custom C# program for each query on data that has been pre-formatted in the most optimal manner for that program is not really comparable to writing a bog standard SQL query.
- danbruc 9y agoI am not sure I understand what you want to say but I assume you want to say that what I did was kind of cheating because I wrote code tailored to that problem and to work on data in a format that makes that problem rather easy? Correct me if I am wrong. But they did exactly the same just that the query planer, optimizer, and compiler generated the code from the SQL query. They still picked a data set, a physical layout of that data set, and a query that would result in maximum throughput. That was not any random SQL query, it was a carefully picked one, chosen because it would be able to take advantage of all possible optimizations.
- deleted 9y ago[deleted]