StoredProc Smart Service vs Entity Query

Lets say I have a view that contains 20cols and 3000 rows, and I want to return all the data to my process.

In terms of performance, would it be better to 

a) Define a StoredProc in the MySQL DB that does a select * from view and call it via the StoredProc Smart Service

or

b) Define an expression rule that contains an entityquery which gets all the data.

In my own mind, I think that the first option would be the slowest as we need to invoke the smart service, call the SP then parse the data, whereas the second option has no smart service to worry about.
or will there be no real difference between the methods as invoking the entity query will take just as long as the smart service ? 


  Discussion posts and replies are publicly visible

Parents Reply Children