Link to home
Start Free TrialLog in
Avatar of redbaron082997
redbaron082997

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Victor Spiridonov
Victor Spiridonov
Flag of Russian Federation image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of redbaron082997
redbaron082997

ASKER

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?
Avatar of Victor Spiridonov
Victor Spiridonov
Flag of Russian Federation image
(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.
Avatar of redbaron082997
redbaron082997

ASKER

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?
Avatar of Victor Spiridonov
Victor Spiridonov
Flag of Russian Federation image
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.