07-23-2023, 04:53 AM
I have logic consisting of selecting a large number of records from one system, performing multiple transformations (based on business rules) and inserting them into another system.
It seems like a high performance (and memory) hit to instantiate each of these records as an object, perform transformations on them and then insert all of these object into the other system.
Is the best way to achieve this in DDD to skip the classes/objects and do it straight through SQL, maybe a stored procedure?
Is there a better way using DDD to achieve this goal?
Note: The systems use SQL databases, at the moment object stores like CouchDB are not an option.
It seems like a high performance (and memory) hit to instantiate each of these records as an object, perform transformations on them and then insert all of these object into the other system.
Is the best way to achieve this in DDD to skip the classes/objects and do it straight through SQL, maybe a stored procedure?
Is there a better way using DDD to achieve this goal?
Note: The systems use SQL databases, at the moment object stores like CouchDB are not an option.