i think it is right to get all my data from db and do calculations with it, i prefer to work "offline" with my data, and not call my db each time i need something
On Aug 6, 9:38 pm, Graham Bunce <[email protected]> wrote: > TBH, NH is not suited for bulk operations (unless you use a special NH > factory). When you get into 100K rows etc. there is high chance of > your app grinding to a halt. > > We had a simple insert routine that took 30mins or more for 100K > records (using the default session). In the end we wrote that specific > function in raw ADO.NET and did it in about 100 secs. By using OLEDB > instead of SQL Server ADO and using basic SQL statements we kept our > database flexibility. > > Sometimes you need a scalpel, not a sledgehammer :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
