CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: TheCPUWizard

Search: Search took 0.23 seconds.

  1. November 17th, 2008, 11:15 AM

    Thread: Parameterized query ( with bind parameters ) running much slower than non-parameteriz

    by TheCPUWizard
    Replies
    5
    Views
    9,082

    Re: Parameterized query ( with bind parameters ) running much slower than non-paramet

    Compare the following (psuedo-code - not intendd to compile)



    class One
    {
    public void Execute(int x)
    {
    SqlCommand cmd = new SqlCommand("select * from foo where...
  2. November 15th, 2008, 12:50 PM

    Thread: Parameterized query ( with bind parameters ) running much slower than non-parameteriz

    by TheCPUWizard
    Replies
    5
    Views
    9,082

    Re: Parameterized query ( with bind parameters ) running much slower than non-paramet

    The most common cause is that the command is being re-created, rather than having a stable instance of the command which is properly "prepared".

    Even this condition is unlikely to have a...
Results 1 to 2 of 2





Click Here to Expand Forum to Full Width

Featured