Re: [bdbxml] problems while indexing a container
George Feinberg <[email protected]> Wed, 10 May 2006 11:27:16 -0400
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <[email protected]> |
Deepak, First, you probably know that it is best to add indexes prior to population, but it's obviously too late for that. A reindex operation like yours should be done without transactions, if possible. It will take a long time, but it should not hang. Are you able to attach to the process with a debugger to get a stack trace when it seems to stop running? Is the dbxml shell process consuming any CPU when it stops growing? Reindexing will cause it to grow, but not without limit, as each document is released once it's indexed. Regards, George > Hi > I have a node container that is about 17gb in size, and has over > 360,000 XML documents in it. > > I populated is first, and now I am trying to index a single XML > element. I am doing this on a Dual Intel Xeon 3.06Ghz machine. After > populating, I opened the container in the dbxml shell and it was fine. > I even tried a 'getDocument' and that worked too. > > The indexing command that I issued in the shell looks like > >> addIndex "" "INSDSeq_locus" "edge-element-equality-string" > > However, this runs for a while and then does not respond, i.e the file > size also stops increasing. Is there anything I can do to find out > what is going on. > > Regards > -- > -------------------- > Deepak Jois > http://deepak.jois.name > > > ------------------------------------------ > To remove yourself from this list, send an > email to [email protected] > ------------------------------------------ To remove yourself from this list, send an email to [email protected]