> If the database is too big, just use last N amount of rows from the database instead of a full dump.
For SQL optimization purposes, you cannot do that – there are high chances you'll get different query plans.
For SQL optimization purposes, you cannot do that – there are high chances you'll get different query plans.
And as I already mentioned in my other comments here, thin cloning is a great way to solve the speed (and money) problem for larger DBs.