Solved

RDO -> seek? How?

Posted on 1998-07-06
5
305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 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