Cursorlocation issue
am 05.06.2007 20:20:25 von shubha.sunkadaHi,
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.