|
 |
asp_web_howto thread: Re: Display Data by calling view or stored pr
ocedure
Message #1 by william.sze@s... on Thu, 20 Jun 2002 17:51:54 -0400
|
|
How about is view taken more resources than a stored procedure?
Lauralyn.Ninow@c...
omtrol.com To: "ASP Web HowTo" <asp_web_howto@p...>
cc:
06/20/02 05:45 Subject: [asp_web_howto] Re: Display Data by calling view or stored
PM pr ocedure
Please respond
to "ASP Web
HowTo"
Doesn't matter what database you're using: Views and StoredProc are always
the fastest route to go, because they are run in a precompiled state by the
database.
Lauralyn Ninow
webmaster @ Comtrol Corporation
http://www.comtrol.com
> -----Original Message-----
> From: william.sze@s... [mailto:william.sze@s...]
> Sent: Thursday, June 20, 2002 4:42 PM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: Display Data by calling view or stored
> procedure
>
>
>
> SQL Server.
>
>
>
>
>
> kyle.b.willman@u...
>
> global.com To: "ASP
> Web HowTo" <asp_web_howto@p...>
> cc:
>
> 06/20/02 05:15 PM Subject:
> [asp_web_howto] Re: Display Data by calling view or stored
> Please respond to procedure
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
>
>
> Are you using Oracle (which version) or SQL Server?
>
> Kyle B. Willman
> PricewaterhouseCoopers LLP
> Office: xxx.xxx.xxxx
> Cell: xxx.xxx.xxxx
>
>
>
> william.sze@s...
>
> om To: "ASP Web HowTo"
> <asp_web_howto@p...>
> 06/20/2002 04:12 cc:
>
> PM Subject:
> [asp_web_howto]
> Display Data by calling view or stored procedure
>
> Please respond to
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
> Hi,
>
> I need to display data into a html table. I'm thinking to
> call either a
> view or a stored procedure to retrieve the data.
>
> The data is going to be obtained by joining 10 tables.
>
> Should I use
> 1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
>
> or
>
> 2. strSQL = "sp_Data 218"
>
> to create recordset and then display into html table.
>
> Which one gives a better performance?
>
> Thanks
> William
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
> eprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/th
> eprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/th
> eprogramme
> r-20
>
>
>
>
> _________________________________________________________________
> The information transmitted is intended only for the
> person or
> entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any
> action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received
> this in error,
> please contact the sender and delete the material from any
> computer.
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
eprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #2 by Lauralyn.Ninow@c... on Thu, 20 Jun 2002 16:45:48 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C218A3.D6AFDA60
Content-Type: text/plain;
charset="iso-8859-1"
Doesn't matter what database you're using: Views and StoredProc are always
the fastest route to go, because they are run in a precompiled state by the
database.
Lauralyn Ninow
webmaster @ Comtrol Corporation
http://www.comtrol.com
> -----Original Message-----
> From: william.sze@s... [mailto:william.sze@s...]
> Sent: Thursday, June 20, 2002 4:42 PM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: Display Data by calling view or stored
> procedure
>
>
>
> SQL Server.
>
>
>
>
>
> kyle.b.willman@u...
>
> global.com To: "ASP
> Web HowTo" <asp_web_howto@p...>
> cc:
>
> 06/20/02 05:15 PM Subject:
> [asp_web_howto] Re: Display Data by calling view or stored
> Please respond to procedure
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
>
>
> Are you using Oracle (which version) or SQL Server?
>
> Kyle B. Willman
> PricewaterhouseCoopers LLP
> Office: xxx.xxx.xxxx
> Cell: xxx.xxx.xxxx
>
>
>
> william.sze@s...
>
> om To: "ASP Web HowTo"
> <asp_web_howto@p...>
> 06/20/2002 04:12 cc:
>
> PM Subject:
> [asp_web_howto]
> Display Data by calling view or stored procedure
>
> Please respond to
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
> Hi,
>
> I need to display data into a html table. I'm thinking to
> call either a
> view or a stored procedure to retrieve the data.
>
> The data is going to be obtained by joining 10 tables.
>
> Should I use
> 1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
>
> or
>
> 2. strSQL = "sp_Data 218"
>
> to create recordset and then display into html table.
>
> Which one gives a better performance?
>
> Thanks
> William
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
> eprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/th
> eprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/th
> eprogramme
> r-20
>
>
>
>
> _________________________________________________________________
> The information transmitted is intended only for the
> person or
> entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any
> action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received
> this in error,
> please contact the sender and delete the material from any
> computer.
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
eprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #3 by kyle.b.willman@u... on Thu, 20 Jun 2002 16:51:49 -0500
|
|
The question was between views or stored procs. When handling a small
amount of records, i.e. non-transaction oriented datasets, you will see a
negligible difference. When handling enormous transaction oriented tables,
views have been faster for me. I am using Oracle 8.1.7
Just my two cents...
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
Lauralyn.Ninow@c...
trol.com To: "ASP Web HowTo" <asp_web_howto@p...>
06/20/2002 04:45 cc:
PM Subject: [asp_web_howto] Re: Display Data by calling view or stored pr ocedure
Please respond to
"ASP Web HowTo"
Doesn't matter what database you're using: Views and StoredProc are always
the fastest route to go, because they are run in a precompiled state by the
database.
Lauralyn Ninow
webmaster @ Comtrol Corporation
http://www.comtrol.com
> -----Original Message-----
> From: william.sze@s... [mailto:william.sze@s...]
> Sent: Thursday, June 20, 2002 4:42 PM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: Display Data by calling view or stored
> procedure
>
>
>
> SQL Server.
>
>
>
>
>
> kyle.b.willman@u...
>
> global.com To: "ASP
> Web HowTo" <asp_web_howto@p...>
> cc:
>
> 06/20/02 05:15 PM Subject:
> [asp_web_howto] Re: Display Data by calling view or stored
> Please respond to procedure
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
>
>
> Are you using Oracle (which version) or SQL Server?
>
> Kyle B. Willman
> PricewaterhouseCoopers LLP
> Office: xxx.xxx.xxxx
> Cell: xxx.xxx.xxxx
>
>
>
> william.sze@s...
>
> om To: "ASP Web HowTo"
> <asp_web_howto@p...>
> 06/20/2002 04:12 cc:
>
> PM Subject:
> [asp_web_howto]
> Display Data by calling view or stored procedure
>
> Please respond to
>
> "ASP Web HowTo"
>
>
>
>
>
>
>
>
> Hi,
>
> I need to display data into a html table. I'm thinking to
> call either a
> view or a stored procedure to retrieve the data.
>
> The data is going to be obtained by joining 10 tables.
>
> Should I use
> 1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
>
> or
>
> 2. strSQL = "sp_Data 218"
>
> to create recordset and then display into html table.
>
> Which one gives a better performance?
>
> Thanks
> William
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
> eprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/th
> eprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/th
> eprogramme
> r-20
>
>
>
>
> _________________________________________________________________
> The information transmitted is intended only for the
> person or
> entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any
> action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received
> this in error,
> please contact the sender and delete the material from any
> computer.
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
eprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
Message #4 by william.sze@s... on Thu, 20 Jun 2002 17:41:35 -0400
|
|
SQL Server.
kyle.b.willman@u...
global.com To: "ASP Web HowTo" <asp_web_howto@p...>
cc:
06/20/02 05:15 PM Subject: [asp_web_howto] Re: Display Data by calling view or stored
Please respond to procedure
"ASP Web HowTo"
Are you using Oracle (which version) or SQL Server?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
william.sze@s...
om To: "ASP Web HowTo"
<asp_web_howto@p...>
06/20/2002 04:12 cc:
PM Subject: [asp_web_howto]
Display Data by calling view or stored procedure
Please respond to
"ASP Web HowTo"
Hi,
I need to display data into a html table. I'm thinking to call either a
view or a stored procedure to retrieve the data.
The data is going to be obtained by joining 10 tables.
Should I use
1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
or
2. strSQL = "sp_Data 218"
to create recordset and then display into html table.
Which one gives a better performance?
Thanks
William
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #5 by kyle.b.willman@u... on Thu, 20 Jun 2002 16:15:55 -0500
|
|
Are you using Oracle (which version) or SQL Server?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
william.sze@s...
om To: "ASP Web HowTo" <asp_web_howto@p...>
06/20/2002 04:12 cc:
PM Subject: [asp_web_howto] Display Data by calling view or stored procedure
Please respond to
"ASP Web HowTo"
Hi,
I need to display data into a html table. I'm thinking to call either a
view or a stored procedure to retrieve the data.
The data is going to be obtained by joining 10 tables.
Should I use
1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
or
2. strSQL = "sp_Data 218"
to create recordset and then display into html table.
Which one gives a better performance?
Thanks
William
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
Message #6 by william.sze@s... on Thu, 20 Jun 2002 17:12:07 -0400
|
|
Hi,
I need to display data into a html table. I'm thinking to call either a
view or a stored procedure to retrieve the data.
The data is going to be obtained by joining 10 tables.
Should I use
1. strSQL = "SELECT * FROM VIEW1 WHERE PartID = 218"
or
2. strSQL = "sp_Data 218"
to create recordset and then display into html table.
Which one gives a better performance?
Thanks
William
|
|
|
View Cart
