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
2561
February 02, 2020 06:51PM
908
February 02, 2020 07:13PM
881
February 02, 2020 10:30PM
882
February 03, 2020 04:16AM
Re: Help on Query with DATE BETWEEN not performant
848
February 03, 2020 08:12AM
1482
February 03, 2020 10:45AM
912
February 03, 2020 11:20AM
836
February 03, 2020 12:02PM
857
February 03, 2020 12:26PM
860
February 03, 2020 04:19PM
1563
February 03, 2020 06:21PM
876
February 03, 2020 08:38PM
1506
February 04, 2020 01:03PM
956
February 04, 2020 01:42PM
1635
February 04, 2020 02:48PM
1519
February 04, 2020 05:26PM
1210
February 04, 2020 05:27PM
832
February 06, 2020 04:21PM
1081
February 06, 2020 04:31PM
1517
February 06, 2020 10:57PM
1212
February 09, 2020 08:46AM
872
February 09, 2020 11:48AM
1562
February 09, 2020 05:04PM
796
February 04, 2020 04:12PM