• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

ODBC opening

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
moktar
Asked:
moktar
  • 3
  • 2
1 Solution
 
chensuCommented:
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
 
babu_sureshCommented:
Its just a matter of caching.
0
 
moktarAuthor Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
chensuCommented:
You may open and close it before the first time you really want to access it.
0
 
moktarAuthor Commented:
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
 
chensuCommented:
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now