Re: Querying Using All Cores

[Chris Hughes]

Hi Phill

Thank you for following this up.

I had assumed that the implicit casting of VARCHAR to DATE (or DATETIME) would have meant STR_TO_DATE would not make a difference. However using your BETWEEN example, the query runs in 19 seconds. An improvement!

The IN example runs in 25 seconds but I can see where you are going with that since the this DATE field is indexed.

I'm starting to think shell scripting is going to be my only option although I acknowledge your warning about using more CPU.

Many thanks.

Chrisp