Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?

by

Aristos, here’s the thing I’m having an issue with. You posted a question to our groups and we had a nice, 23-long email exchange. You insisted that SubSonic 3 has problems and you asked me why I haven’t fixed this “slow, broken tool”.

I tried to explain to you that, with 233 tables, SubSonic has to read the schema of EACH ONE on load up. This isn’t typical usage for SubSonic 3, but we do it this way so it’s actually FASTER than SubSonic 2 on subsequent loadups.

You’re ingoring this. I’m answering you. RBarry left a comment above that I was beind “denigrating”. I’m quite frustrated. You seem to think that I haven’t benchmarked this thing and I have, MANY MANY times. I can’t turn out an ORM with problems like the one you suggested, and I didn’t.

You have to understand that if it took SubSonic 10 seconds to run a query, then it wouldn’t be used.

So – your answer: 233 tables, scripted out as classes, need to load to Provider memory on first run.

That’s too many. SubSonic isn’t your tool.

More Related Contents:

  1. Why is Skylake so much better than Broadwell-E for single-threaded memory throughput?
  2. What is microbenchmarking?
  3. How to benchmark efficiency of PHP script
  4. Comparing BSXFUN and REPMAT
  5. How can I accurately benchmark unaligned access speed on x86_64?
  6. Is LINQ to SQL Dead or Alive?
  7. How to do a join in linq to sql with method syntax?
  8. Spark: Inconsistent performance number in scaling number of cores
  9. LINQ Ring: Any() vs Contains() for Huge Collections
  10. Why does this delay-loop start to run faster after several iterations with no sleep?
  11. Trial-division code runs 2x faster as 32-bit on Windows than 64-bit on Linux
  12. Getting an accurate execution time in C++ (micro seconds)
  13. Java benchmarking – why is the second loop faster?
  14. python: deque vs list performance comparison
  15. Python Requests vs PyCurl Performance
  16. Python Slice Assignment Memory Usage
  17. Explicit construction of entity type ‘###’ in query is not allowed.
  18. Order of the code and performance
  19. NOLOCK with Linq to SQL
  20. Common Table Expression (CTE) in linq-to-sql?
  21. Convert SQL to LINQ to SQL
  22. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  23. Is it possible to force an existing Java application to use no more than x cores?
  24. Python Numpy Data Types Performance
  25. T4 template to Generate Enums
  26. How to load data quickly into R?
  27. Using System.Data.Linq in a Razor view
  28. Simple for() loop benchmark takes the same time with any loop bound
  29. Is A==0 really better than ~A?
  30. linq to sql: join multiple columns from the same table

Leave a Comment