[CWB] [ cwb-Bugs-2893729 ] CQPweb: text_metadata_for_* indexes
SourceForge.net
noreply at sourceforge.net
Sat Nov 28 09:38:41 CET 2009
Bugs item #2893729, was opened at 2009-11-07 06:46
Message generated for change (Comment added) made by andrewhardie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=2893729&group_id=131809
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: CQPweb
Group: None
Status: Closed
Resolution: None
Priority: 9
Private: No
Submitted By: Andrew Hardie (andrewhardie)
Assigned to: Andrew Hardie (andrewhardie)
Summary: CQPweb: text_metadata_for_* indexes
Initial Comment:
Searching for any category takes FOREVER is the metadata table is big (ie many texts).
So, all "classification" fields should have indexes on them.
Query: should "free text" fields have indexes? This will take up rather a lot more disk space, as every entry is different, and the free text fields are much more rarely searched on (only for one rather obscure mode of subcorpus creation).
----------------------------------------------------------------------
>Comment By: Andrew Hardie (andrewhardie)
Date: 2009-11-28 08:38
Message:
Conclusion: free text fields should NOT have indexes. So, the
"classification fields only" indexing will be kept as is and not extended
to free text metadata.
----------------------------------------------------------------------
Comment By: Andrew Hardie (andrewhardie)
Date: 2009-11-10 21:51
Message:
Done in update 58 (for classification fields only).
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=2893729&group_id=131809
More information about the CWB
mailing list