Some more information about my saving problem. The file is constructed like this :
<session>4 ; 2006-05-23T13:33:43.000+02:00 ; 2006-05-23T13:48:14.000+02:00</session>
<session>1 ; 2006-05-18T10:56:36.000+02:00 ; 2006-05-18T10:56:36.000+02:00</session>
<session>1 ; 2006-05-22T12:59:57.000+02:00 ; 2006-05-22T12:59:57.000+02:00</session>
<session>2 ; 2006-05-08T12:31:18.000+02:00 ; 2006-05-08T12:31:41.000+02:00</session>
<session>6 ; 2006-05-25T11:43:33.000+02:00 ; 2006-05-25T11:56:39.000+02:00</session>
...
And I should have roughly 7M lines (thus the estimate is more like 10Mo). I tested your idea from CLI but can't get BaseX to work with my database. It's certainly a syntax problem, but I can't find how to select a database in the Xquery. Here is what I tried :
for $session in doc('xmlSessions')/logSessionArgs/logSession
let $nbAction := count($session/search_log_entry)
let $start := data($session/search_log_entry[1]/@date)
let $end := data($session/search_log_entry[$nbAction]/@date)
return (
<session>{$nbAction} ; {$start} ; {$end}</session>
)
Given that 'xmlSessions' is the name of the database. I also tried "basex:db(..." and "collection(..." instead of 'doc(...' but it leads to the same error :
[XPDY0002] No context item set for 'nbActionStartEndPerSession.xq'.