Large number of individual writes

This warning is raised when the profiler detects that you are writing a lot of data to the database. Similar to the warning about too many calls to the database, the main issue here is the number of remote calls and the time they take.

Unlike the more common Select N+1, the issue with this alert isn't with the number of selects, but with the number of write statements (delete, create, update) that are being sent to the database. The PLinqO has a batching feature that can help you here, allowing you to specify a Linq query that would be translated to a write statement immediately (instead of turning it into a select and then a write).

Last update: 11/13/2009 7:52:45 AM