Re: [PERFORM] View vs Stored Proc Performance

2009-09-11 Thread Jason Tesser
at 2:56 PM, Jason Tesser > wrote: > > OK so in my case I have a Person, Email, Phone and Address table. I want > to > > return the Person and an Array of the others. so my return type would be > > something like Person, Email[], Phone[], Address[] > > > >

Re: [PERFORM] View vs Stored Proc Performance

2009-09-11 Thread Jason Tesser
that as oppessed to 1. defining a type for a function to return or 2. a function that returns 4 out parameters (Person, Address[] ,) Thanks On Fri, Sep 11, 2009 at 1:37 PM, Merlin Moncure wrote: > On Fri, Sep 11, 2009 at 11:46 AM, Jason Tesser > wrote: > > Is it faster to use a

[PERFORM] View vs Stored Proc Performance

2009-09-11 Thread Jason Tesser
Is it faster to use a Stored Proc that returns a Type or has Out Parameters then a View? Views are easier to maintain I feel. I remember testing this around 8.0 days and the view seemed slower with a lot of data.