[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

RDO -> seek? How?

Posted on 1998-07-06
5
Medium Priority
?
322 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:
Victor Spiridonov earned 40 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:Victor 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:Victor 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

649 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