• Shishir Jaiswal's avatar
    Bug#16212207 - LOAD XML INFILE PERFORMANCE WITH INDENTED · 3b562dcf
    Shishir Jaiswal authored
                   XML
    
    DESCRIPTION
    ===========
    LOAD XML INFILE performance becomes painfully slow if the
    tags' value has any space(s) in between them. They're
    usually kept intentionally for indentation purpose.
    
    ANALYSIS
    ========
    The extra spaces are calling clear_level() many a times
    which is having overhead of clearing taglist etc. This can
    be avoided altogether by skipping all such spaces.
    
    FIX
    ===
    Trim all the starting whitespaces from the value before
    passing it to read_value()
    3b562dcf
sql_load.cc 60 KB