I have a long transaction (taking hours) with all tables within the
transaction
are temporary tables with no log and locked in exclusive mode, thus
there will be no LOG
usage and less LOCK usage. Is this scenario will impact the database
server performace?

Thanks for any reply and consultation.

On Jan 29, 6:19 am, falcons... (AT) gmail (DOT) com wrote:
The best way to get real performance answers is TEST IT!

But think about it. There are always some resources used. You never
defined the performance you are concerned will be impacted. These
transactions takes CPU cycles if nothing else, but I bet they also
takes shared memory, disc space, index space, table space, and others
resources.

You also did not mention which DBMS or platform (OS and hardware). The
question is too generic.

So what is really your problem??
Ed

On Jan 29, 6:19 am, falcons... (AT) gmail (DOT) com wrote:
The best way to get real performance answers is TEST IT!

But think about it. There are always some resources used. You never
defined the performance you are concerned will be impacted. These
transactions takes CPU cycles if nothing else, but I bet they also
takes shared memory, disc space, index space, table space, and others
resources.

You also did not mention which DBMS or platform (OS and hardware). The
question is too generic.

So what is really your problem??
Ed

On Jan 29, 6:19 am, falcons... (AT) gmail (DOT) com wrote:
The best way to get real performance answers is TEST IT!

But think about it. There are always some resources used. You never
defined the performance you are concerned will be impacted. These
transactions takes CPU cycles if nothing else, but I bet they also
takes shared memory, disc space, index space, table space, and others
resources.

You also did not mention which DBMS or platform (OS and hardware). The
question is too generic.

So what is really your problem??
Ed