Cursorlocation issue

Discussion in 'ASP General' started by shubha.sunkada@fds.com, Jun 5, 2007.

  1. Guest

    Hi,

    I have a recordset connection in asp that I am using to search
    records.If I use the client side cursorlocation (rs.cursorlocation=3)
    then it takes really long to return back the records due to which a
    timeout occurs.If I change the cursorlocation to adUseNone(1) or
    adUseServer(2) then the search is faster and without any problems.
    But the sort on records cannot be done if I use adUseClient(3).I
    need to have sort on these records. I am using dynamic server side
    cursor.Also my result set is not huge ..just 80 records.One more
    thing that is wierd is that the result set comes back instantly for
    the
    first search,but takes forever when searched again for the same
    criteria.
    Eveytime I logout and login and do the search for the 1st time the
    search is quick and takes forever for consequnt searches.

    Any help is appreciated.
     
    , Jun 5, 2007
    #1
    1. Advertisements

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. Satinderpal Singh

    AppDomain Issue...

    Satinderpal Singh, Oct 27, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    836
    Dan Ignatov
    Oct 27, 2003
  2. Catherine Jones

    rich text box issue

    Catherine Jones, Dec 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    843
    Robert Jacobson
    Dec 11, 2003
  3. AJ

    Datatype issue

    AJ, Jan 12, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    605
    Mattias Sjögren
    Jan 12, 2004
  4. Replies:
    0
    Views:
    837
  5. Bari

    Installation Issue

    Bari, Feb 25, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    775
    Sanjai Thomas
    Feb 27, 2004
  6. Shaun Ram

    Debugging issue

    Shaun Ram, Feb 29, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    422
    Shaun Ram
    Feb 29, 2004
  7. Srini
    Replies:
    11
    Views:
    1,249
    Arne Vajhøj
    Jun 1, 2008
  8. Replies:
    10
    Views:
    428
    Bob Barrows [MVP]
    Jun 6, 2007
Loading...