ans Bouma
> Sent: Friday, 11 August 2006 22:32
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
>
> > No.
>
> yes, read on :)
>
> > I had a view called "Web_User":
> >
> > Select fi
the
> query was created
>
> -Original Message-
> From: Discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED] On Behalf Of Dean Cleaver
> Sent: 11 August 2006 10:55
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005
Of Frans Bouma
Sent: Friday, 11 August 2006 22:32
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
> No.
yes, read on :)
> I had a view called "Web_User":
>
> Select fields from tableA, tableB, tableC where clau
act as tables, there the view usage is
> much faster, as the query of the view is bypassed as the
> results are used directly
>
> FB
>
>
> >
> > -----Original Message-----
> > From: Discussion of advanced .NET topics.
> > [mailto:[EMAIL PROTECTED] On
ced .NET topics.
> [mailto:[EMAIL PROTECTED] On Behalf Of Frans Bouma
> Sent: Friday, 11 August 2006 19:13
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
>
>
> A view is just a query, so a query utilizing
EMAIL PROTECTED] On Behalf Of Dean Cleaver
Sent: 11 August 2006 10:55
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
In my experience, that's not correct.
-Original Message-
From: Discussion of advanced .NET topics.
[mai
:[EMAIL PROTECTED] On Behalf Of Frans Bouma
> Sent: Friday, 11 August 2006 19:13
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
>
>
> A view is just a query, so a query utilizing a view
&
Behalf Of Dean Cleaver
Sent: 11 August 2006 10:55
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
In my experience, that's not correct.
-Original Message-
From: Discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Beha
In my experience, that's not correct.
-Original Message-
From: Discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Frans Bouma
Sent: Friday, 11 August 2006 19:13
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml que
roved the speed dramatically.
>
> Dino
>
> -Original Message-
> From: Discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED] On Behalf Of Phil Sayers
> Sent: Friday, 11 August 2006 06:17
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: Re: [ADVANCED-DO
10, 2006 5:13 PM
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
Yes, views can be a performance problem, to do with the table scans, and
indexing (or lack thereof) when i had a huge IN statement querying my
view it caused problems,
ct: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
Views are you friend.
create views that each do 4 or 5 joins making sure you SELECT the fields
you need. then use those views in your main query.
but if you need all the jons, then you may have to resign yourself to
"this is what it takes
You can also build up a query as a string within your Stored procedure and
then use the EXEC function executing the string .
Phil Sayers <[EMAIL PROTECTED]> wrote: Views are you friend.
create views that each do 4 or 5 joins making sure you SELECT the fields you
need. then use those view
@DISCUSS.DEVELOP.COM
Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
Views are you friend.
create views that each do 4 or 5 joins making sure you SELECT the fields
you need. then use those views in your main query.
but if you need all the jons, then you may have to resign yourself to
Views are you friend.
create views that each do 4 or 5 joins making sure you SELECT the fields you
need. then use those views in your main query.
but if you need all the jons, then you may have to resign yourself to "this
is what it takes to get the results as defined by requirements" so you go
15 matches
Mail list logo
