Re: Insert Into ... Select, Delte Data

[Hans Henrich]

You´re right Rick, the real table have more than 150 million rows. Also there run more than one java application. Each application store more than 100 (sometimes more than 500) rows every secound.

At the moment all applications writing each new row directly into the real table (a).
The aim of the new behavoir is to minimize the write traffic in the real table (a) because "Table_locks_waited" is overmuch and this slows down the application. Now each application shall creat an own table b during runtime, in there the application "batch" its entrys and write them into the real table when table b size is over XXXX.

Thank you, creating a secound temporary table sounds well! I already tought about it but would ask if anyone knows a query what operates like "cut" in the file system.