MyQuery.FetchAll False, do Open & Last

[GEswin]

Hi

I'm just optimitng a little bit a programm. When I open a query with lots of records and set fecthall to false, it's very quick, but if i do a myquery.last , it takes more time and looks like it d/l everything. Is there any way to do a last and only d/l required records ?

Right now I'm doing a LIMIT , but I would like to avoid this.

Thanks in advance,

[Ikar]

No, there is no such way. More over, a task of retrieving a lot of records on client side quite seldom meets in practice. Are you sure, that your task just like this?

PS: Have you got to know with restrictions of FetchAll = False?

[GEswin]

I have only found one situation with this. It's a programm to send/receive SMS messages, it has thousends of messages send and received. Users just like to scroll up or down in a grid where they see all the messages, just as it was outlook. Right now I only show the last 2000 messages received & 2000 sended.

Yes i know the limits of not using FetchAll, but right now I'm looking for a good solution to this situation.

[Ikar]

MySQL API doesn't provide interface for fast execution Last without retrieving all data on client side.