Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>Hi Naomi,
>>
>>I believe the first is marginally faster. I could be wrong, but I think I remember that there's a lot more processing going on with an INSERT due to VARCHARMAPPING and other late changes.
>>
>>Shame I don't have source code access anymore :-)
>
>You mean scatter memvar is faster? Both tables have almost identical structures... Too bad I switched, now I have to switch back <g>
>
>My tests seems to confirm it, because I believe after my change the speed decreased. Though it's really hard to tell, because in addition I'm getting Invalid Seek Offset on about each third attempt, which really drives me nuts...
Naomi - if you really want to figure out why your code is so slow, run it with Coverage Logging on and see where the bottlenecks. Much more efficient than this long thread.
Tamar
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