Subject Re: Need to speed up process
Author Svein Erling Tysvær
--- In, "ra8009" <ra8009@y...> wrote:
> Becuase of a design "issue" that I inherited, I need to run a
> conversion that will use 81 update statements almost 9500 times
> each. Of course I'm building the statements dynamically.
> As you can imagine this takes some time. What steps can I take to
> speed things up?

The only general advice I would give, is to ascertain that you
dynimically build only 81 update statements, prepare them once and use
parameters for the update. Commit for every 10000 updates
(approximately, less if each update modifies many records - I think).
If you want more specific help, ask a more specific question. Here are
something worth mentioning:

How complex are the updates?
How do you build and call the updates?
How many records does each update modify?
What are the size of the tables, and what is the index selectivity?
How long time does the update process take?
How short time are you trying to achieve?