Hello,
it seems that the drop query itself takes only 12 seconds
but another query is executed just after (not asked by me) LOAD STDIN
"V1DataSimu2".
LOG 24/11/2008 15:43:36 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- DROP DOCUMENT("V1DataSimu2")
LOG 24/11/2008 15:45:48 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- LOAD STDIN "V1DataSimu2"
LOG
24/11/2008 15:46:23 (TRN elb sid=48 trid=49)
[socket_client.cpp:socket_client::close_file_from_client:330]:
Temporary file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
Here is my function for asking drop
int SednaDbXml::ExecuteUpdate(struct SednaConnection& a_db, string a_query)
{
int iDbReturnValue;
// execute query
iDbReturnValue = SEexecute(&a_db, a_query.c_str());
if(iDbReturnValue != SEDNA_UPDATE_SUCCEEDED)
{
std::cout << "Update failed:" << endl;
std::cout << SEgetLastErrorMsg(&a_db) << endl;
//closing session
//SEclose(&a_db);
return EXIT_FAILURE;
}
return EXIT_SUCCESS;
}
It
seems that the problem is that query --- LOAD STDIN "V1DataSimu2"
which takes too long and is automatically executed after the drop by sedna
server itself. This query isn't a "user query" like the log says since i never
sent such query.
What is its purpose ? Can't it be avoided ? thanks :)
-----La pièce jointe correspondante suit-----
LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=-1) [tr.cpp:TRmain:251]: Session
is ready
LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$collections') return $b
LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$documents')//documents/document return $b
LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$indexes') return $b
LOG 24/11/2008 15:40:30 (TRN elb sid=49 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document("V1DataSimu") return $b
LOG 24/11/2008 15:40:32 (TRN elb sid=49 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document("V1DataSimu2") return $b
LOG 24/11/2008 15:40:51 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:251]: Session
is ready
LOG 24/11/2008 15:40:53 (TRN elb sid=48 trid=48)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- DROP DOCUMENT("V1DataSimu")
LOG 24/11/2008 15:40:57 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- LOAD STDIN "V1DataSimu"
LOG
24/11/2008 15:41:34 (TRN elb sid=48 trid=49)
[socket_client.cpp:socket_client::close_file_from_client:330]:
Temporary file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
SYS 24/11/2008 15:41:41 (SM elb) [uhdd.c:uIsFileExist:369]: GetFileAttributes
(code = 2): Le fichier spécifié est introuvable.
LOG 24/11/2008 15:41:41 (SM elb) [trmgr.cpp:checkpoint_thread:172]:
Checkpoint procedure is finished
LOG 24/11/2008 15:41:41 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- document("V1DataSimu")/ * / *
LOG 24/11/2008 15:43:36 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- DROP DOCUMENT("V1DataSimu2")
LOG 24/11/2008 15:45:48 (TRN elb sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:79]: User query:
--- LOAD STDIN "V1DataSimu2"
LOG
24/11/2008 15:46:23 (TRN elb sid=48 trid=49)
[socket_client.cpp:socket_client::close_file_from_client:330]:
Temporary file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
SYS 24/11/2008 15:46:32 (SM elb) [uhdd.c:uIsFileExist:369]: GetFileAttributes
(code = 2): Le fichier spécifié est introuvable.
INFO 24/11/2008 15:46:32 (SM elb) [bm_core.cpp:bm_log_out_io_statistics:525]:
IO block reads:24569, writes:31634
LOG 24/11/2008 15:46:32 (SM elb) [trmgr.cpp:checkpoint_thread:172]:
Checkpoint procedure is finished
LOG 24/11/2008 15:46:32 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:533]: Session
is closed
________________________________
De : Ivan Shcheklein <[EMAIL PROTECTED]>
À : Prémon Nom <[EMAIL PROTECTED]>
Cc : [email protected]
Envoyé le : Vendredi, 21 Novembre 2008, 17h31mn 53s
Objet : Re: [Sedna-discussion] Sedna Drop document really slow on large
documents
Hi Prémon,
Can you send us this document to troubleshoot?
In case you can't, send us please event***.log file(s) (located at
SEDNA_DIR/data folder).
Ivan Shcheklein,
Sedna Team
On Wed, Nov 19, 2008 at 7:38 PM, Prémon Nom <[EMAIL PROTECTED]> wrote:
Hi everyone,
I'm learning Sedna and doing some benchmarks on large documents (the resulting
XML is about 50 MB).
Inserting the xml document (using C API) takes about 38 seconds. Deleting it
after using the DROP DOCUMENT "mydoc" command is really long (2 minutes !)
If someone has an explanation to why this command takes so long to execute, a
tip to decrease this time or an advice on what i may be doing wrong, i thank
you in advance.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=-1) [tr.cpp:TRmain:251]: Session is ready
LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$collections') return $b
LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$documents')//documents/document return $b
LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document('$indexes') return $b
LOG 24/11/2008 15:40:30 (TRN elb sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document("V1DataSimu") return $b
LOG 24/11/2008 15:40:32 (TRN elb sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- for $b in document("V1DataSimu2") return $b
LOG 24/11/2008 15:40:51 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:251]: Session is ready
LOG 24/11/2008 15:40:53 (TRN elb sid=48 trid=48) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- DROP DOCUMENT("V1DataSimu")
LOG 24/11/2008 15:40:57 (TRN elb sid=48 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- LOAD STDIN "V1DataSimu"
LOG 24/11/2008 15:41:34 (TRN elb sid=48 trid=49) [socket_client.cpp:socket_client::close_file_from_client:330]: Temporary file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
SYS 24/11/2008 15:41:41 (SM elb) [uhdd.c:uIsFileExist:369]: GetFileAttributes (code = 2): Le fichier spécifié est introuvable.
LOG 24/11/2008 15:41:41 (SM elb) [trmgr.cpp:checkpoint_thread:172]: Checkpoint procedure is finished
LOG 24/11/2008 15:41:41 (TRN elb sid=48 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- document("V1DataSimu")/ * / *
LOG 24/11/2008 15:43:36 (TRN elb sid=48 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- DROP DOCUMENT("V1DataSimu2")
LOG 24/11/2008 15:45:48 (TRN elb sid=48 trid=49) [tr_functions.cpp:on_user_statement_begin:79]: User query:
--- LOAD STDIN "V1DataSimu2"
LOG 24/11/2008 15:46:23 (TRN elb sid=48 trid=49) [socket_client.cpp:socket_client::close_file_from_client:330]: Temporary file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
SYS 24/11/2008 15:46:32 (SM elb) [uhdd.c:uIsFileExist:369]: GetFileAttributes (code = 2): Le fichier spécifié est introuvable.
INFO 24/11/2008 15:46:32 (SM elb) [bm_core.cpp:bm_log_out_io_statistics:525]: IO block reads:24569, writes:31634
LOG 24/11/2008 15:46:32 (SM elb) [trmgr.cpp:checkpoint_thread:172]: Checkpoint procedure is finished
LOG 24/11/2008 15:46:32 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:533]: Session is closed
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
