Versions des environnements
Database:
Jet/Access Engine
J'aime (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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement