How to display database query results of 100,000 rows or more with HTML?

I have done just what you are describing using the following (which works very well):

jQuery Datatables

It enables you to do 'fetch as you scroll' pagination, so you can disable the pagination arrows in favor of a 'forever' scroll.

Give a try with Jquery scroll.

Instead of image scroll , you need to have data scroll.

You should poulate data in the divs , instead of images.

http://www.smoothdivscroll.com/#quickdemo

It should work. I wish.

You gotta great client anyway :-)

Something related to your Q

http://www.9lessons.info/2009/07/load-data-while-scroll-with-jquery-php.html

http://api.jquery.com/scroll/

I'm using Open Rico's LiveGrid in a project to display a table with thousands of rows in a page as an endless scrolling table. It has been working really fine so far. The table requests data on demand when you scroll through the rows. The parameters are send as simple GET parameters and the response you have to create on the serverside is simple XML. It should be possible to implement a data backend for a Rico LiveGrid in Python.