>Hi Juan,
>
>>Would it be better to write a C fll to perform this? My worry is that calling back to VFP (_DBSkip()) would yield the same speed, eventhough I can expect speed increase in other calculations.
>
>Probably not. The _DB functions are almost unchanged since 2.5. They have numerous bugs that don't get fixed and only can work in the default datasession. I haven't tested whether they correctly work with buffering and transactions, but I would at least be careful about such an assumption.
>
>If you have time consuming calculations, put them into a DLL or an ActiveX control (they are faster to call), but leave the data handling in VFP.
>
>Christof
_______________________________________________________________________________
Thanks for your input. I will try both suggestions given by you and Cetin.
I would need to create a prototype for both scenarios. One sure thing to watch is the overhead incurred when calling and passing parameters to DLLs.
I tried Cetin's option (
www.frontsys.com,they are the developer for Excel's Solver), but have yet to successfully prototype the problem modal.
Regards,
Juan