-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: smart boy
Message 4 in Discussion
If the database has large number of records and you are using a highly
complex query, then SP will show a significant improvemnt in performance
over a quary written directly within the exe file. We replaced Queries in
the EXE file with SP (on SQL Server 2000) in a costing software and the
response time of some processes changed from 45 seconds to as low as 11
seconds.
The main benefit of SP is that ADO.net does not need to get the entire data
from the server to the client pc and then process it. The server processes
the data and then sends only the processed data to the client. I think that
is probably where the main saving is.
Regards
Saswata
----- Original Message -----
From: "AjaySingala[Synergetics]" <[EMAIL PROTECTED]>
To: "MumbaiUserGroup" <[EMAIL PROTECTED]>
Sent: Saturday, January 31, 2004 12:34 PM
Subject: Re: Is stored procedures faster?
-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: AjaySingala[Synergetics]
Message 3 in Discussion
Hi Mary,
1) SPs are definitely faster, but like Nauzad said, how fast is debatable.
2) U need not recompile UR app if all settings are provided in the xml
config file.
3) For processing "clicks" of ToolBar buttons, you use the ButtonClick
method of the ToolBar control as follows:
private void toolBar1_ButtonClick(object sender,
System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
// Find out which button was clicked.
switch (e.Button.Text)
{
case "Add":
// Do Add.
case "Delete":
// Do Delete.
:
:
}
}
HTH.
Regards,
Ajay Singala [Synergetics].
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your
E-mail Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On
the pre-addressed e-mail message that opens, simply click "Send". Your
e-mail address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
