On Thu, 15 Mar 2012, Benoit Thiell wrote: > The problem was that the index on the bibxxx tables that holds these > fields has the default length of 35 and the 35 characters of this > timestamp are always equal. So basically the index was useless and a > single query took between 0.5 and 1 second. Now, with an index with a > length of 200, the query takes less than a millisecond.
This is what we did for some bibxxx tables in the past, notably for the ones storing URLs (bib85x). Maybe we can do this more generally for other tables too. Did you compare MYD and MYI table and index sizes from before and after your change? Best regards -- Tibor Simko
