Cristina Durana Chambre de Sá Moita wrote:
>
> Hi all? How are you?
> I have this problem to solve for an aplication that I have to do:
> what is more rapid, robust and eficient: download from a query to an
> array or use LIMIT..., to limitated the registries that I obtained from
> the query?
> In your opinion, what do I use?
> Thanks in advance
> Cristina
Hi Cristina
This depends on the amount of rows and the row size you get with your query.
If there are only 100 rows with under 100 bytes, the array-way will be more efficient.
If there are several thousands of rows each some KBytes big, the LIMIT-way is the one
to go.
The only disadvantage with multiple LIMIT selects I can see, is the possibility of
INSERT's or DELETE's between your SELECT's. This
can corrupt your client results (you can get a row multiple times or loose one for
each INSERT respectively DELETE).
Tschau
Christian
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
