Environment versions
Database:
Jet/Access Engine
Likes (1)
Naomi Nosonovsky
>Succumbed ?
:-}
Doesn't take me long to get bored with lying by a pool.....
>
>
>>What do you mean by "computes the total of a document that can contain up to a few hundred lines."
>>What document? What computation ?
>>
>>>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.
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