We have, and SPT wins every time. In fact we're currently in the process of converting a massive data import application from using remote views to SPT for performance reasons. Maintaining 165 remote views is not fun!
SPT has much less overhead, and you don't have to deal with the database container. Of course, this means you have to take care of all the housekeeping yourself in code, so if time is a factor, remote views will get you up and running faster. But if you have the time, I'd recommend the pass-through method.
Just my 2¢!
>Has anyone done any comparisons on SQL pass through and remote view as to which is better gives you better performance?
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
