How to run my Curser more faster?

Discussion in 'Microsoft Certification' started by =?Utf-8?B?cmFq?=, Nov 29, 2004.

  1. I have a stored procedure written for number of updates, inserts to the
    database. This stored procedure takes too long to run. I have created few
    indexes around few tables, but the response time is not that defferent.
    THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
    another stored procedure is called within this Curser. I found that lot of
    time been taken to run this Curser. So I want to run/make it faster the
    curser. So how should I improve the Curser to run more faster
    I would greatly appreciate anyone's idea or suggesions.

    thanks

    raj
    =?Utf-8?B?cmFq?=, Nov 29, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?cmFq?=

    Mark Guest

    It's not a good idea to mess with the windows32 api to tweak around an
    application. Better to consider optimizing your code or boosting the
    hardware requirements.



    "raj" <> wrote in message
    news:...
    > I have a stored procedure written for number of updates, inserts to the
    > database. This stored procedure takes too long to run. I have created few
    > indexes around few tables, but the response time is not that defferent.
    > THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
    > another stored procedure is called within this Curser. I found that lot of
    > time been taken to run this Curser. So I want to run/make it faster the
    > curser. So how should I improve the Curser to run more faster
    > I would greatly appreciate anyone's idea or suggesions.
    >
    > thanks
    >
    > raj
    Mark, Dec 9, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bill Showengerdt

    Agent curser problem

    Bill Showengerdt, Jul 16, 2003, in forum: Computer Support
    Replies:
    3
    Views:
    536
    Bill Showengerdt
    Jul 19, 2003
  2. Cat Man

    Curser freezes

    Cat Man, Jul 3, 2004, in forum: Computer Support
    Replies:
    2
    Views:
    800
    Barry OGrady
    Jul 4, 2004
  3. WeeWilly

    Help- Curser Disappearing

    WeeWilly, Nov 24, 2005, in forum: Computer Support
    Replies:
    6
    Views:
    427
  4. Dee

    curser settings help?

    Dee, Jun 11, 2007, in forum: Computer Information
    Replies:
    1
    Views:
    395
    Yes Baby
    Jun 12, 2007
  5. Jim S

    Curser problem?

    Jim S, Sep 25, 2007, in forum: Computer Support
    Replies:
    5
    Views:
    461
    Plato
    Oct 7, 2007
Loading...

Share This Page