I have two tables named Table 1
Y Table 2
, having a size of 9 GB and 200 MB respectively.
Table 1
have 200 & # 39; 000 + records and Table 2
have 700 & # 39; 000 + records.
I am using the following query for both tables, but table 1 takes forever to load records into higher compensation values WHILE table 2 is loading records faster!
SELECT
*
SINCE
table1 AS t
WHERE
t.date_created> = UNIX_TIMESTAMP (& # 39; 2013-11-18 & # 39;)
And t.date_created <= UNIX_TIMESTAMP (& # 39; 2018-11-22 & # 39;)
REQUESTED BY t.date_created DESC
LIMIT 10 DISPLACEMENT `highest adjustment value outside
EXTRA:
-
Ont
Table 1
I'm usingIn t
datatype to store the date by converting throughunix_timestamp ()
function and inTable 2
I usuallyDate and Time
type of data. -
Table 1 loads data slower than table 2