Database.QueryLocator:

50 Million records can be returned.

Iterable<sObject>:

Governor limits will be enforced. So, we can use upto 50,000 records only. Else, exception will be thrown.

You can also use the iterable to create your own custom process for iterating through the list.