Page 1 of 1
MyQuery.FetchAll False, do Open & Last
Posted: Fri 12 Nov 2004 10:37
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
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
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
MySQL API doesn't provide interface for fast execution Last without retrieving all data on client side.