Solved

ODBC opening

Posted on 1998-08-11
6
177 Views
Last Modified: 2013-11-20
I've written an application that use a ODBC database.
The program works fine, but there is a little problem :

The first time I open the DB wiht DB.Open(), this opening takes a long time.
After if I do a DB.Close() and reopen the DB, it is immediate.

Does someone know where comes the problem from and how to solve it ?

0
Comment
Question by:moktar
  • 3
  • 2
6 Comments
 
LVL 23

Accepted Solution

by:
chensu earned 100 total points
ID: 1320623
After opening and closing, it is cached. It will be much faster next time it is reopened since the system accesses it from the cache. It is reasonable if it does not take too long for the first time.
0
 

Expert Comment

by:babu_suresh
ID: 1320624
Its just a matter of caching.
0
 

Author Comment

by:moktar
ID: 1320625
There is not a way to make the first opening faster ?

Because my program works in real time, so the first request slows the execution.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 23

Expert Comment

by:chensu
ID: 1320626
You may open and close it before the first time you really want to access it.
0
 

Author Comment

by:moktar
ID: 1320627
Well, if it is the only way, I will try this.

But if it takes the datas from the cache, should I do a Requery after the openeing or is it done automatically?
0
 
LVL 23

Expert Comment

by:chensu
ID: 1320628
It depends on the system implementation. Normally the opening takes much time and the system should caches the important information for you. You may not need to do a query.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction: Dynamic window placements and drawing on a form, simple usage of windows registry as a storage place for information. Continuing from the first article about sudoku.  There we have designed the application and put a lot of user int…
Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now