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.


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