>Hi,
>I'm still studying and testing in order to transform our application into a client/server one.
>
>Our data centric forms show a pageframe, within the first page there's a grid bounded to the table the user wants to handle.
>I'm in trouble trying to make this grid to work (well) with SPT, since after a lot of reading I've excluded RVs.. or at least I'll try to use them as my last resource.
>
>Actually my grid shows without problem the result of an SPT, but waiting for 10000 records to be fetched is not very fun. :(
>I've also tried to use the "FetchAsNeeded" approach - and it works -, but even if the grid appears immediately, the result is that:
>- you have to wait in order to move to the bottom of the table
>- the vertical bar is not correct.
>
>In a few words I'm in that phase were I'm wondering if I'm tilting at windmills.
>Is my approach practicable or not?
>
>Thank you.
10000 records are NOTHING. SPT should return almost immediately with FULL table.
We work here with more that 100 000 records at a time and have no problems.
What is the value of Asynchronous property of your sql Connection?
UPDATE: I just saw you use MySQL! I have little to no knowledge to that DB. Sorry.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.