Needless to say, this isn't going to be very good for my pagination through the data.

Is there some sort of setting I need to adjust in order to have the limit statement work quicker. I'm a bit confused why it would take SO much longer when it's returning the same number of rows and just starting in a place further along the path. The seek time on these hard drives can't be THAT slow.