Last questions ADO lead to memory leaks, looking for solutions,
Can confirm that at the time of use ADO to open the database, even if the CLOSE database in time, memory will increase some, not completely released, which is memory leaks,
Saw many posts online, such a person is more, this problem is less solution, said in the way to disconnect from the database, for a period of time in the connection, the purpose is to make the system have the time or the memory, but the test is invalid, and ADO version upgrade, but I have is the latest version of ADO, it's still a memory leak,
Finally: certainly no problem, just open the ADO database of these statements a logout, memory leaks immediately disappear,

Excuse me, the warrior are: are there any other solutions? DELPHI ADO can also be used if no other way to access the database?

CodePudding user response:

Can try control data sets, such as: UiDAC, etc.

CodePudding user response:

Has been using ado to connect to the database, and found no memory leaks cause the program can not run normally,

CodePudding user response:

Only in the frequent use of ado database will appear only when memory leaks, so generally save the data of what you don't see what problem, especially the long running open close the database, the problem is exposed,

CodePudding user response:

Do not go away this time, implore you,,,

CodePudding user response:

You repeatedly opening and closing, such as a 1000 or 10000, observe whether memory usage is rising, if yes, can prove there is memory leak, open only one or two, there is no point
On the issue of the fragments of memory, is...

CodePudding user response:

Is open 1000 or 10000, observe memory continue to rise, there is a memory leak

CodePudding user response:

Please the original poster is a database connection? I have a memory leak test is found connecting Oracle, MS SQL found no

But if the upgrade ADO version should be able to solve the problem of Oracle memory leaks, but I haven't verify, because high version

The ADO to install in the Server version

CodePudding user response:

My connection is ACCESS, however, should have nothing to do with what the database, but and ADO itself,

CodePudding user response:

refer to 6th floor bwe2009 response:

1000 or 10000 is open, see memory continue to rise, there were some memory leaks

If is the access database, ADO operation happens when a memory leak, but the problem of ADO, or data access problem is to say, every day I used to write software from access database using ADO to operate inside, no problem running for more than a year,

CodePudding user response:

references 9 f yct0605 response:

refer to 6th floor bwe2009 response:
Is to open 1000 or 10000, see memory continue to rise, there were some memory leaks
If is the access database, ADO operation happens when a memory leak, but the problem of ADO, or data access problem is to say, I used to write software from access database using ADO to operate inside every day, running for more than a year are no problem,

There is a problem or no problem? Said will leak, and said to run tome problem occurs in one year, which is it?

CodePudding user response:

Does anyone know? What should I do?

CodePudding user response:

This problem is still true have never thought about it, waiting for the answer,

CodePudding user response:

Continued strength in advance,

CodePudding user response:

ADO to the latest version of how to obtain?? Thanks [email protected] how to download

CodePudding user response:

To continue, please master

CodePudding user response:

Skeptical, made under fastmm tracking test

CodePudding user response:

Small white pass, help, have been using ado, never found, may be I use the time period,

CodePudding user response:

Use sqlie directly with access, more comfortable?

CodePudding user response:

What is sqlie?

CodePudding user response:

All say that let you install fastmm, used to detect and track the root cause of memory leaks to locate leaks,
Sqlite is one of the best embedded database,

CodePudding user response:

If you don't want to send time to solve the problem of "ado" memory leaks, and then try to use sqlite,
Use it directly with sqlite, API database operation, do not need any other drive, sqlite only need to bring a sqlite3. DLL and a database file is all for it, with cb, project directly join sqlite3. Compiling c files, even the sqlite3. DLL all need not take,

CodePudding user response:

The

refer to 21st floor sololie response:

if you don't want to send time to solve the problem of "ado" memory leaks, and then try to use sqlite,
Use it directly with sqlite, API database operation, do not need any other drive, sqlite only need to bring a sqlite3. DLL and a database file is all for it, with cb, project directly join sqlite3. Compiling c file, even the sqlite3. DLL all need not take,

CodePudding user response:

I also have been ADO this memory leaks, MDAC version is 2.8, WINDOWS 2008 server, is caused by frequent, speaking, reading and writing, and help the top up, there is a problem we contact QQ2211549

CodePudding user response:

The

refer to 21st floor sololie response:

if you don't want to send time to solve the problem of "ado" memory leaks, and then try to use sqlite,
Use it directly with sqlite, API database operation, do not need any other drive, sqlite only need to bring a sqlite3. DLL and a database file is all for it, with cb, project directly join sqlite3. Compiling c file, even the sqlite3. DLL all need not take,

Do the brothers, you said a SQLITE can replace project in need of SQL SERVER 2005?

CodePudding user response:

This problem is still true have never thought about it, waiting for the answer,

CodePudding user response:

Are you so-called memory leaks in the client or on the server side? If sure is a problem of database on the server side, if the client could be ado, database or Delphi components related questions,
My database online number about 200 people at the same time, haven't restart the server for about 3 years, running very stable, to recognize the development mode is ado + Delphi

CodePudding user response:

Should be your design code has a memory leak, check your code again,

CodePudding user response:

So many years, the server can it?

CodePudding user response:

So many years, the server can it?