Hi I have a bigger collection
DDR-All Database Properties Name: DDR-All Size: 743 MB Nodes: 33340760 Height: 8
Database Creation Source Path: D:/var/TICEReports/JSDI data/bezne Time Stamp: 26.10.2010 02:08:30 Input Size: 542 MB Encoding: utf-8 Documents: 79313 Whitespace Chopping: ON Entity Parsing: OFF
Indexes Path Summary: ON Text Index: ON Attribute Index: ON Full-Text Index: OFF
When I run xquery count(//MSG) it shows result 511990, which is correct. However, it takes a lot of time to produce that result. I thought, that with existing indices it shall bring the result in seconds, and not in minutes (like 10 minutes) Note, that I have created the collection before 6.3 was released, so this might be the case and I would have to import it all again.
I was trying to run xquery, using indices xquery basex:index('MSG', 'path') xquery basex:index('//MSG', 'path') but I got a feeling, I do not got it properly, as it responds "Unknown index path"
What I would like to know is
- names of indices available - what is basex:index function usable for and for what it is not - can I create my own indices? Like calculating date from dateTime fileds in XML. I guess it is not supported. - any further reading? Most of the description is related to full text, but this is not my case.
Jan
PS: Despite of some performance problems (query lasting 25 minutes) I was able to dig out some very valuable information, which would be inefficient and probably much more error prone in any other way. http://janvlcinsky.s3.amazonaws.com/projects/Monitor/websamples/timeplot/tge...