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. 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. JohnFol
    Replies:
    0
    Views:
    1,333
    JohnFol
    Aug 6, 2003
  2. Satinderpal Singh

    AppDomain Issue...

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

    rich text box issue

    Catherine Jones, Dec 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    729
    Robert Jacobson
    Dec 11, 2003
  4. Srini
    Replies:
    11
    Views:
    971
    Arne Vajhøj
    Jun 1, 2008
  5. Replies:
    10
    Views:
    325
    Bob Barrows [MVP]
    Jun 6, 2007
Loading...

Share This Page