How to add speed when run sql execute command?

Hi,
the problem i'm facing when i run the sql is when i run
the command- executenonquery or executescalar(), the
system needs a long time to process before come out a
result.
i'm using Intel P4 1.5GHz, 256 RAM.
Can anyone tell me that how to add speed when execute the
sql command'?
thanks.There can be many reasons why the command executes slowly. DDL statements
(Cretae Table etc.), demo data (Insert statements) and the command you re
sending would definitely help solving the problem. You can use Query
Analyzer to anayze the T-SQL query you are sending - you can see the
execution plan and find worst operations, like table scans, sorts...
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.|||What sort of command are you executing? It will be a good idea to have a
look at the actual query.
--
With Regards,
Deepak
[I code, therefore I am]
http://deepakictim.blogspot.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.