Lookup vs. Variables
I'm wondering if someone could please give me the advantages and disadvantages between using lookups vs using variables to copy over the information from one place to another.
The way I see it, is that although it's more of a pain to initially setup, look ups are better as all you need to do is copy in a record ID and everything else takes care of itself. You never have to worry about forgetting to create a variable when there are lots of fields to transfer. On the other hand I've been told that on a large scale, this sort of method can hinder the systems performance. What I was told was the use of relationships in general slows things down. Is this true? For scalability's sake, am I best to always use variables in my script steps to move over data?