in reply to Re: Re: Re: Re: It's bad manners to slurp
in thread It's bad manners to slurp

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;

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Re: It's bad manners to slurp
by samtregar (Abbot) on Apr 29, 2004 at 20:03 UTC
    Care to elaborate? I'm unfamiliar with HANDLER.

    -sam

      It's some kind of low-level SELECT. You can't do complex queries or joins with HANDLER. You can just walk the table from the beginning to the end, optionally by using simple restrictions like > or =. The result of a "HANDLER READ" statement is a complete row, there's no way to select single rows. The advantage is speed and less memory consumption.