>>I'm looking for a way to speed up a calculation routine that computes the total of a document that can contain up to a few hundred lines. The routine is slow now because for each line I access the db. I'm looking for a way to implement this in a more data oriented way.
>>
>>In VFP I would have dumped the relevant keys into a cursor and then join the tables to the cursor in an sql statement.
>>
>>I could of course simulate this by dumping the keys into a temporary table (which if I'm right would not limit the amount of times I access the db), but I was wondering if there is not a more "elegant" way to do this.
>>
>>TIA.
>
>
>Okay, I'll bite. Bring down all the data and use linq to perform your calculations...
As I said somewhere else, when I grow up, I will implement SQL server :). From what I understand, Linq is not available for Access databases.
Thanks and kind regards,
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.