Increase c# list performance

by

The problem is not the length of the list but the number of SQL queries. If you have 160 elements you have at list 161 sql statements which seems to be very slow in your case (use a profiler to analyze). You can try to modify your linq query to join the required products with the users. I don’t know your data model, but it could be something like this:

var users = from u in dbContext.Users.Include(u => u.Product);

or

var products = from p in dbContext.Products.Include(p => p.User);

Eager loading instead of lazy loading.

More Related Contents:

  1. Find index of returned list result C#
  2. Difference between List and array when initiating [closed]
  3. Why not inherit from List?
  4. What is the best way to modify a list in a ‘foreach’ loop?
  5. How to get values of selected items in CheckBoxList with foreach in ASP.NET C#?
  6. Adding items to a LIST of objects results in duplicate Objects when using a NEW in a Loop
  7. C# List to string with delimiter
  8. Is there a performance impact when calling ToList()?
  9. Combination of List
  10. Is it worthwhile to initialize the collection size of a List if it’s size reasonably known?
  11. How can I find a specific element in a List?
  12. How to get the closest number from a List with LINQ?
  13. How can I list the contents of a .zip folder in c#?
  14. c# When should I use List and when should I use arraylist?
  15. .Contains() on a list of custom class objects
  16. Convert rows from a data reader into typed results
  17. Compare two Lists for differences
  18. A list of multiple data types?
  19. Conversion from List to array T[]
  20. Can Newtonsoft Json.NET skip serializing empty lists?
  21. Case-Insensitive List Search
  22. convert List to IList
  23. List size limitation in C#
  24. IEnumerable vs IReadonlyCollection vs ReadonlyCollection for exposing a list member
  25. Binding Listbox to List in WinForms
  26. Get a list of distinct values in List
  27. C# List – Removing items while looping / iterating [duplicate]
  28. How to sort a list / array of string version number?
  29. How do I get the list of keys in a Dictionary?
  30. How to convert c# generic list to json using json.net?

Leave a Comment