Re: Help on Query with DATE BETWEEN not performant
one more thing ... When the slow query succeeds then the second time it is run it is in milliseconds ...
but that is probably due to the caching ... right ?
btw ... I did optimize all three tables involved
Subject
Views
Written By
Posted
1592
February 02, 2020 06:51PM
646
February 02, 2020 07:13PM
634
February 02, 2020 10:30PM
604
February 03, 2020 04:16AM
Re: Help on Query with DATE BETWEEN not performant
614
February 03, 2020 08:12AM
630
February 03, 2020 10:45AM
619
February 03, 2020 11:20AM
593
February 03, 2020 12:02PM
625
February 03, 2020 12:26PM
627
February 03, 2020 04:19PM
858
February 03, 2020 06:21PM
628
February 03, 2020 08:38PM
593
February 04, 2020 01:03PM
628
February 04, 2020 01:42PM
965
February 04, 2020 02:48PM
595
February 04, 2020 05:26PM
615
February 04, 2020 05:27PM
557
February 06, 2020 04:21PM
663
February 06, 2020 04:31PM
620
February 06, 2020 10:57PM
604
February 09, 2020 08:46AM
609
February 09, 2020 11:48AM
567
February 09, 2020 05:04PM
565
February 04, 2020 04:12PM