John Baird
Coatesville, Pennsylvania, United States
Environment versions
Database:
Jet/Access Engine
>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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only