If inscribe!!!!!
A use PB program, would have a memory in the SQL database, using DESTORY also useless, only after exit PB program, memory will be cleared of SQL, don't know how to remove! Please advice! First thank you!!!

CodePudding user response:

As long as the use of database, of course, I'll use memory,
No empty, is still in use!
And the database itself has a memory management! The database memory cannot touch

Application will use memory, according to the size of the amount of data.
General DW has several buffer, are put in memory, only the reset () or exit, will release!

Is the key issue is to reduce the data volume!

CodePudding user response:

With the database?

CodePudding user response:

Upstairs, two brothers, I am using PB8 SQLserver2000, database used for 4 years, the size of around 10 g, blocking phenomenon now! Also examined some programs, is write up destroy; Don't know have no good way to solve the jam? I see the database memory is bigger, don't know there is no method to improve some!!!!!!!!!!

CodePudding user response:

Are all very good advice! Worth learning

CodePudding user response:

No, for the top