This content has been marked as final. Show 27 replies
It's good to know that the execution of the request has no degradation.
For the transactional environment, DBXML (BDB) has to open and deal with log files and region files (including locking subsystem). So it does make sense that transactional environment cost a longer time.
Since you said that by running db5_recover you can get correct response times. I just doubt if there are something wrong in the environment. It would be great if you can provide a program to reproduce the issue. Thanks.
You mentioned that "But after a few thousand I/O, opening the container can be counted in seconds". Could you please tell me the exact number? e.g.: 5 seconds, 7 seconds. Thanks.
Oracle Berkeley DB XML
It seems that the environment does not be closed correctly.
* try the flag "DBXML_ADOPT_DBENV" (http://download.oracle.com/docs/cd/E17276_01/html/api_reference/CXX/XmlManager.html).
* Refer http://download.oracle.com/docs/cd/E17276_01/html/gsg_xml_txn/cxx/envopen.html to check your transactional environment configuration.
If the problem still can not be solved, please show me your code that how you open/close DB_ENV and/or XmlManager.
sorry for this answer so late, but I expected that my environment will take time to respond.
This time the container will not open even through the prompt DBXML.
Here is how I instantiate my environment and I open the containers.
/* Exemples of my code */
define("FLAGS", DB_CREATE | DB_INIT_LOCK | DB_INIT_LOG | DB_INIT_MPOOL | DB_INIT_TXN | DB_THREAD | DB_RECOVER | DB_REGISTER);
$oEnv = new Db4Env();
$oManager = new XmlManager($oEnv, DBXML_ALLOW_EXTERNAL_ACCESS | DBXML_ALLOW_AUTO_OPEN | DBXML_ADOPT_DBENV);
// Test exist
$bEnable = IS_WRITE ? true : false;
$oConfig = new XmlContainerConfig();
$oContainer = $oManager->createContainer('myContainer.dbxml', $oConfig);
I don't understand.
When I delete my environment (__db *) and I recreated, I have no problem.
Edited by: gdievart on 31 janv. 2011 04:16
I can't provide the complete code, but the procedures followed are those of the above.
To know that I insert and remove approximately 500 documents per day + updates.
Reading about 50,000 per day or more.
I'll try removing the auto-indexing, but I don't see how the index would have any influence on the opening of the container.
At the flags that I pass to the opening of my environment, I do not mistake?
Thank you for your investment.
I will also provide you with my configurations file DB_CONFIG for you to tell me what you think.
Edited by: gdievart on 31 janv. 2011 12:46