This is intended to be a high level question. I have some objects I need stored in the database, so since I love orchard I made them Content parts and it works great.
Here is an example of my part
I made AddressRecord/AddressPart and ContactInfoRecord/ContactInfoPart
they just have basic string fields with things you might guess in them.
My PlayerPart also keep Address and ContactInfo as lazy fields
ok, so heading to my question, everything works nicely. I need to be able to do some backend work where I get a large collection of these (think 10k) and do some stuff with them. This will probably happen as a result of a trigger in a workflow I hope. Right
now I tried something like this
It is very slow, and I am looking for a best practice way of doing this:
- I could go straight to SQL and do it myself (old school) but I want to do things the orchard way.
- I think skipping the parts and just dealing with the records could be good.
- Some magic way of doing this that some one will share with me and it will be awesome and really fast.
Thanks in advance.