Re: Re: Re: Re: Re: It's bad manners to slurp

[eserte]

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;

[samtregar]

Care to elaborate? I'm unfamiliar with HANDLER.

-sam

[eserte]

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.