It might be worthwhile having a look at Class::DBI::Pager. It handles this sort of thing for you, although I have a feeling that it doesn't use LIMITs on the select statements. So if your queries really are massive, it won't solve the problem you are facing. It does however simplify getting ranges of data when using Class::DBI.

- Cees