Mike,
>Not sure what you mean by sucking down the entire table every time. Why would you want to do that? Read it once and then loop through the data in an interface with the GUI layer.
Not on web apps and maybe not if you're dealing with millions of records in a backend database accessed from a desktop app.