You need to tell us more details about WHAT you are actually doing. Post the HQL and probably some details about the calculations.
There is no general solution for 100K records. There is no "If you have 100K records, just use feature X". There is some trade-off. It depends on the situation which way is appropriate. To give you a clue on what solutions could be considered: - HQL where: you load only the data you need - HQL select: you load only the columns you need - HQL fetch: you tell NH how to load objects more efficient - SQL select: do the calculations in the db, get only results from the DB - SQL update: you update the data in the database, without loading - HQL update (?) - Stored Procedures: you don't load any data and let the DB do everything - Mapping: You classes could probably be mapped more efficient - Solutions I don't know - Completely different solutions because I didn't understand the root of your problem. On 7 Aug., 08:47, Raul Carlomagno <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
