G
Gabriel
Hi,
My access application dealing with oracle back end database, and every night
it runs an append query procedure to append a set of recordset (coming from
several complex queries) into one single table.
We decide to use this table instead of directly using complex queries 'on
the fly' due to performance reasons and also base on data population
procedures.
Now we facing performance problem when running this append queries.
Can anyone give a clue on this issue, what technique should I use to avoid
this problem. What is the best approach should I use : batch updating, using
transactions or any other technique.
FYI : the append queries procedure should run from Access application since
the data source coming from different Oracle instance and we use stored
queries in access to combine this data.
TIA
Gabriel
My access application dealing with oracle back end database, and every night
it runs an append query procedure to append a set of recordset (coming from
several complex queries) into one single table.
We decide to use this table instead of directly using complex queries 'on
the fly' due to performance reasons and also base on data population
procedures.
Now we facing performance problem when running this append queries.
Can anyone give a clue on this issue, what technique should I use to avoid
this problem. What is the best approach should I use : batch updating, using
transactions or any other technique.
FYI : the append queries procedure should run from Access application since
the data source coming from different Oracle instance and we use stored
queries in access to combine this data.
TIA
Gabriel