MySQL Forums
Forum List  »  InnoDB

Re: Help on Query with DATE BETWEEN not performant
Posted by: Peter Brawley
Date: February 04, 2020 05:26PM

> > 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.

Options: ReplyQuote

Written By
Re: Help on Query with DATE BETWEEN not performant
February 04, 2020 05:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.