udpindex

Thursday, 15 November 2012 · 3 messages · last reply 17 Nov 2012
MC
Mahlow Cerstin15 Nov 2012 13:01 #
Hi, as far as I can see, UPDINDEX cannot be set in the GUI when creating a database. Is this correct? So how would I proceed to change my existing database created without this option and updated and queried by users constantly into an database with this option to make retrieval faster? Is it correct that with UPDINDEX true there is no need anymore to "optimize" the index from time to time? Initially I thought of exporting the existing DB as XML and then using this as source for a new DB with UPDINDEX set true. How do I do this without the GUI? Oh, and could you please make it possible to choose UPDINDEX as an option in the GUI? Best regards Cerstin
-- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow at unibas.ch Web: http://www.oldphras.net
CG
Christian Grün15 Nov 2012 19:56 #
Hi Cerstin, currently, the UPDINDEX provides incremental support for the value index structures (texts and attribute values). It will be mapped to the GUI as soon as the path and fulltext will also be able to do incremental updates. If you want to test the flag, you can use the input line on top of the GUI and type in "set updindex on" in the "Command" mode before creating a new database. Hope this helps, Christian
Quoted text · Mahlow Cerstin · 36 lines
On Thu, Nov 15, 2012 at 1:01 PM, Mahlow Cerstin <cerstin.mahlow at unibas.ch> wrote: > Hi, > > as far as I can see, UPDINDEX cannot be set in the GUI when creating a database. Is this correct? > > So how would I proceed to change my existing database created without this option and updated and queried by users constantly into an database with this option to make retrieval faster? Is it correct that with UPDINDEX true there is no need anymore to "optimize" the index from time to time? > > Initially I thought of exporting the existing DB as XML and then using this as source for a new DB with UPDINDEX set true. How do I do this without the GUI? > > Oh, and could you please make it possible to choose UPDINDEX as an option in the GUI? > > Best regards > > Cerstin > -- > Dr. phil. Cerstin Mahlow > > Universität Basel > Deutsches Seminar > Nadelberg 4 > 4051 Basel > Schweiz > > Tel: +41 61 267 07 65 > Fax: +41 61 267 34 40 > Mail: cerstin.mahlow at unibas.ch > Web: http://www.oldphras.net > > > > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
CM
Cerstin Elisabeth Mahlow17 Nov 2012 21:08 #
Hi Christian,
Quoted text · Christian Grün · 1 line
Am 15.11.2012 um 19:56 schrieb Christian Grün:
currently, the UPDINDEX provides incremental support for the value index structures (texts and attribute values). It will be mapped to the GUI as soon as the path and fulltext will also be able to do incremental updates. I tested it and it seems to be enough to have text and attribute indexes up to date. I hope this will also solve another issue I have with slow processing: When searching the TEI collection, I always query the "collect" DB, too to provide users with hits they already saved and to make sure nothing is stored twice there. Thus, a growing "collect" DB with broken indexes slows down everything and causes server time outs. Best regards Cerstin
-- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow at unibas.ch<mailto:cerstin.mahlow at unibas.ch> Web: http://www.oldphras.net<http://www.oldphras.net/>

⚡Generated with XQuery