mysql – Does the size of the table affect the performance of the query?

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 using In t datatype to store the date by converting through unix_timestamp () function and in Table 2 I usually Date and Time type of data.

  • Table 1 loads data slower than table 2