RDO -> seek? How?

How do you perform a seek or the best equivalent to it? I have a jet app that keeps a recordset open and seeks for positioning to find the proper data. I am trying to upsize it to SQL, due to speed, and I am not sure what the proper method would be.
LVL 1
redbaron082997Asked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
You should never use Jet seek method with  SQL Server . Instead try using restrictive WHERE clause to find you data.
0
 
redbaron082997Author Commented:
Thanks. In Jet, it was much quicker to keep a table open, since it took so long to process the query. In SQL, does the same apply, or should I only open a resultset for the needed values, and close it? It seems that with the lack of a seek, it would be very hard for me to leave my inv file open, and find the inv item that I am looking for.  So I am faced with executing a openresultset(select * from inv where itmno = 100) or whatever each time.  Is there a faster way?
0
 
Victor SpiridonovCommented:
(select * from inv where itmno = 100) -will be the fastest -because you will not have to drag the whole table from the server to the client over the network, just selected rows.
0
 
redbaron082997Author Commented:
If I am reading only, what is the fastest cursor? I would be using an RDOresultset. Also, would it be faster to have this as a stored parameter query?
0
 
Victor SpiridonovCommented:
There is a very good book "Hitchikers Guide to Visual Basic And SQL server" ( I'm note sure how it is spelled), that explains in great details all possible connection options and techniques. You can find answers for the most of your questins there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.