$db->do("declare imprecator CURSOR FOR select * from test");
    $c = $db->prepare("FETCH 100 FROM imprecator")

    for (1..10) {   # I have a more robust example somewhere
        $c->execute();
        print Data::Dumper::Dumper($c->fetchall_arrayref())
    }
[download]

Another way for simple queries with MySQL 4.x is to use the HANDLER statement.

HANDLER table OPEN;
HANDLER table READ FIRST;
HANDLER table READ NEXT;
[download]

Care to elaborate? I'm unfamiliar with HANDLER.

-sam

Interesting. However, according the DBD::mysql docs mysql_use_result "tends to block other processes." I'm not sure what that means exactly but it doesn't sound good! I think I'll stick with LIMIT and OFFSET...

-sam

Still - it's something that shows a fundamental lack of understanding of large-scale database management issues that this behavior is the default for these two drivers (and no, I don't know if it's the driver's fault or the underlying API)

Michael