Solved

RDO -> seek? How?

Posted on 1998-07-06
5
292 Views
Last Modified: 2006-11-17
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.
0
Comment
Question by:redbaron082997
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 10 total points
ID: 1091667
You should never use Jet seek method with  SQL Server . Instead try using restrictive WHERE clause to find you data.
0
 
LVL 1

Author Comment

by:redbaron082997
ID: 1091668
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
 
LVL 7

Expert Comment

by:spiridonov
ID: 1091669
(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
 
LVL 1

Author Comment

by:redbaron082997
ID: 1091670
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
 
LVL 7

Expert Comment

by:spiridonov
ID: 1091671
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question