Feature Requests item #2902566, was opened at 2009-11-23 17:12
Message generated for change (Tracker Item Submitted) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2902566&group_id=56967
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: SQL - general
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Nobody/Anonymous (nobody)
Summary: Improve (i)like preformance on diverse stringdata
Initial Comment:
Using an 'index' that is able to differentiate on stringlength a typical string
lookup can be improved. Using a 2.4M row string table, the (smallint) lookup
consisting of string length is done in less than 200ms. The same 'fulltext'
operation using %the string%, takes around 2500ms. Using a combination
string_size >= length('string') and string ilike '%string%' the first lookup
time can be reduced.
The (i)like operation has be striped from modifiers, due to the constant length
we can assume that the string therefore always be longer.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2902566&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
