MySQL Workbench -- How to efficiently review large database tables? I have a database table with 900,000+ rows, 20 columns, mostly string data.  Using MySQL Workbench, I want to page through the entire contents of the table to see what exactly has been inserted into the table (I am reviewing it because I believe my code somehow accidentally only partially loaded the contents of a CSV file and I want to understand why and where the process ceased loading the entire CSV file).  

The problem is that, because of the somewhat large size of the DB table, running a "SELECT * FROM..." query with "Don't Limit" causes my computer to take far too long (over 10 minutes) to produce a result in MySQL Workbench's result grid and basically appears to freeze up.

Is there a way to make the MySQL Workbench result grid load much much faster?  Or should I be using a different tool?  

I'm a bit of a noob, so it's possible I'm doing something pretty stupid here.
Thanks in advance!
The first suggestion was to use the "pager less" command - but as pointed out, even at 10 pages a second, it would take 25 hours to get through 900,000 records. 

Unfortunately, the "pager" command doesn't work on Windows. It was then suggested to send the output to a file and scroll through that - looking for a disconnect between the .csv input and the final table.

Then, this was proposed

    Or!! You could save your table as a .csv (with a different name  
to your original file) and then do a diff on the files - that might 
immediately show up problems? 


This appears to have resolved the issue for the OP.