Page 1 of 1

MyQuery.FetchAll False, do Open & Last

Posted: Fri 12 Nov 2004 10:37
by GEswin

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,

Re: MyQuery.FetchAll False, do Open & Last

Posted: Fri 12 Nov 2004 14:43
by 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?

Posted: Sun 14 Nov 2004 21:03
by 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.

Posted: Tue 16 Nov 2004 09:10
by Ikar
MySQL API doesn't provide interface for fast execution Last without retrieving all data on client side.