> I have mapped the guilty data as a collection of components, property of a >> parent business entity (as its lifetime is tighly coupled to its container, >> and it has nice benefits when inserting and deleting the parent container). > > > Do you mean that you have an entity with a collection of thousand of > details ? > > Please answer "No". >
Yes! YES! (you asked for it) I have to persist a multidimensional matrix in a relational database, and not as a byte[] array. So the best way I founded is to linearize it and persist the linear matrix. So a 600 * 500 * 20 matrix (for a simple tri-dimensional matrix) becomes a 6 000 000 item collection. In order to map it the best way I found is to wrap it in a converter which, when mapped with nhibernate, converts a matrix of n dimensions in a matrix of 1 dimension + metadata. Of course if anybody has a better idea I'd gladly take it, but google itself has no answer to how to map a multidimensional matrix in a relational database. That kind of shit happens. IRL. >> Would that mean I need to create an IInterceptor which would >> load/save/delete with ado.net the collection when the container entity is >> loaded/saved/deleted with nhibernate? > > > No I mean don't use NH to insert 6000000 records. > > >> I must admit I lack of experience (junior engeneer here) and I do not know >> well how ado.net works in background. >> My collection can grow up to 6 millions items (rows), so if ado.netgenerates >> an insert by item, it would still make 6 million insert >> statements. How would ado.net be faster that nhibernate in this case? > > > a collection with 6 millions of items ????!!!??!??!? > > better to stop here. > Sorry for taking your time. Thanks anyway. Have a good day. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
