Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Ron Katriel
Christian, Thanks for sharing that. I assumed all along that this happens automatically. Anyway, I ran my query (for one drug, to save time) and see the following in the Info view - apply text index for "Lenalidomide" I believe the slow execution may be due to a combinatorial issue: the cross

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Christian Grün
Our documentation should help you here: http://docs.basex.org/wiki/Indexes Ron Katriel schrieb am Fr., 3. Aug. 2018, 23:20: > Hi Christian, > > Yes, I created a full-text index when the databases where loaded (see the > commands below). I also verified that FTINDEX is true for both databases

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Ron Katriel
Hi Gerrit, Thanks for the suggestions. I would like to retain the original diacritics (for output purposes) but only match them when warranted (e.g., match acétazolamide to acétazolamide, but not acétazolamide to acetazolamide). I am looking for a simple solution that does not involve modifying

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Ron Katriel
Hi Christian, Yes, I created a full-text index when the databases where loaded (see the commands below). I also verified that FTINDEX is true for both databases (in the GUI under Database > Open & Manage). How do I ensure that my query is rewritten for index access? Thanks, Ron SET FTINDEX

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Christian Grün
Hi Ron, Did you a) create a full-text index for your data and b) ensure that your query is rewritten for index access? Best, Christian On Fri, Aug 3, 2018 at 2:39 PM Ron Katriel wrote: > > Christian, > > Adding diacritics sensitive slows execution by a factor of 3. My script > (fragment

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Imsieke, Gerrit, le-tex
Hi Ron, You can add an extra element (or attribute) to the content when importing or modifying it. (Or another document in another database if you like – you can create and later find such an index document by giving it the same db:path as the original document.) In this extra database,

Re: [basex-talk] diacritics sensitive not working

2018-08-03 Thread Ron Katriel
Christian, Adding diacritics sensitive slows execution by a factor of 3. My script (fragment below), which joins two large databases, namely CT.gov and DrugBank, takes 2 hours without the diacritics sensitive constraint but 6 hours with it. Given the combinatorics