Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB ADO Index by Date

Posted on 2011-02-27
2
Medium Priority
?
678 Views
Last Modified: 2012-05-11
Is it possible to index a database with a date field?  I have a database that has 2 million records and would like to search records by the transaction date.  Using the ADO seek will work but takes a long time.  Not sure how to do about this, if it possible at all.  I am using VB 6.0 with ADO.  The database is an Advantage Database.  I can also use SQL too, I guess.  Any thoughts or comments would be appreciated.
0
Comment
Question by:grandrew
2 Comments
 
LVL 46

Accepted Solution

by:
aikimark earned 2000 total points
ID: 34994509
Open the database with the Advantage database console, select the table, click Add Index and select the date field.

Note, that date fields may include a time-of-day component and might not give you the results you want if you expect day granularity.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

971 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