Yesterday, I was implementing a module which reads from a file and then populate the Sitecore fields. The main issue I was facing is the datasources of the Treelist, MultiList, Droplink and so on. The query in the datasources were complexed.
Following the past few days, I have been working on a proof of concept which is based on the Sitecore Pattern Cards. The concept of Pattern Cards is to map profile values to specific types of visitors and implement personalization rules.
Sitecore Publishing Service (SPS) is a great module designed by Sitecore. The SPS module provides an enormous gain in publishing performance. Large number of items including media items can be published in less than 10 mins. You may read my previous post on the installation of the Publishing Service 1.0 here.