MMBase

Add dont-care option for mm:constraint tag, which uses the fastest option depending on database type

Details

  • Description:
    Hide
    Searching case-sensitive is much slower on MySQL than case insensitive.
    Sometimes it does not care which option it takes (sensitive or not) as long as it is speedy.

    This new option should use the fastest method possible, depending on the specific database.
    Probably this option should by default do the 'dont care' option.
    Show
    Searching case-sensitive is much slower on MySQL than case insensitive. Sometimes it does not care which option it takes (sensitive or not) as long as it is speedy. This new option should use the fastest method possible, depending on the specific database. Probably this option should by default do the 'dont care' option.

Activity

Hide
Michiel Meeuwissen added a comment - 2009-10-22 16:11
I think this would involve changes to search-query framework (to accodomate the setting) and storage layer (to inform about the database preference) too.
Show
Michiel Meeuwissen added a comment - 2009-10-22 16:11 I think this would involve changes to search-query framework (to accodomate the setting) and storage layer (to inform about the database preference) too.

People

Dates

  • Created:
    2009-10-22 16:09
    Updated:
    2010-04-20 17:30