How to run my Curser more faster?

Discussion in 'Microsoft Certification' started by Guest, Nov 29, 2004.

  1. Guest

    Guest Guest

    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
     
    Guest, Nov 29, 2004
    #1
    1. Advertisements

  2. Guest

    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.
     
    Mark, Dec 9, 2004
    #2
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.