Man...If you can't put lazy="false" in a collection mean that collection shouldn't be there.
2009/5/25 Nelson Cabral <[email protected]> > > 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. > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
