Re: Help on Query with DATE BETWEEN not performant

[Peter Brawley]

> > it could be something about the
> "group_concat_max_len" attribute
> being to small ...

Not a query you've posted.

> we still found a slow query ...

On the query we've been working with, it's a fetch bottleneck.

> when we get a list of articles we do a
> search for a word inside one of 5 text
> columns that I need to put into SELECT

No text columns in the DDL you posted. If there's a problem, let's see that query and the DDL it depends on.

> regexp was slower then LIKE ...

Yes, that's computationally inevitable.

> SELECT query that has Title,subtitle,body,author,summary ...
> then the fetch takes 56 seconds every time

Yes, Text/Blob fetch in volume is slower the bigger the text/blob volume. Why in the world would you be fetching many rows of text data? Search them on the server, fetch just the bits that need to be returned.

> newly created indexes on new date columns
> are not used if I use BETWEEN ...

Can't replicate that, can you post a sql script with enough Inserts to allow replication of the effect.