johnf wrote: > On Friday 02 March 2007 12:03, Paul McNett wrote: >> johnf wrote: >>> In the VFP world a grid fetches data as needed if the view >>> property "FetchAsNeed" is set. DBAPI 2.0 has fetchmany and arraysize. >>> Has anyone attempted to use fetchmany with a dabo grid? Is it there and >>> I missed it? >> Dabo implicitly calls fetchall(), so there is no support at this time >> for fetchone() or fetchmany(). >> >> However, we should change this post-1.0 so that only x number of records >> are fetched at first, and then the dCursor automatically fetches more as >> needed. There are quite a few assumptions that would have to be changed >> to make this work, however. >> >> And it wouldn't be a setting in dGrid, but in dCursor and dBizobj. >> >> >> _______________________________________________ >> Post Messages to: [email protected] >> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev > > Thanks Paul. I'm still playing with idea's on how best to use Dabo. > Although, I built a lookup form some issue still are present. I.e. I have a > customer with thousands of customer who customer number start with "S". If I > let him retrieve thousands of records I sure it be to much for the system.
Make sure thousands of records will be a problem. I once burned up 2 weeks trying to avoid pulling 100k jpegs over the lan unless they were going to be viewed. (the pull wasn't the problem, it was updating what had been pulled that caused issues.) Eventually I gave up and let the 500k of data fly around the wire a few times an hour. It may be a problem at Amazon.com or something, but it wasn't a problem I needed to solve for my client, and they were pretty pissed off at the 2 week delay. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
