| Perfomance in Delete and Insert [message #279749] |
Sat, 10 November 2007 02:10  |
mohseni
Messages: 3
Registered: November 2007
Location: india
|
Junior Member |
|
|
Hi,
I want to delete many rows from my primary table(on db1) and insert them into another table in another database(db2).
How can i delete records from primary database(db1) and insert them into second database(db2) by over 500 record per second performance.
Thanks.
[Updated on: Sat, 10 November 2007 02:21] Report message to a moderator |
|
|
|
|
|
| Re: Perfomance in Delete and Insert [message #279795 is a reply to message #279749] |
Sat, 10 November 2007 06:30  |
mohseni
Messages: 3
Registered: November 2007
Location: india
|
Junior Member |
|
|
I speak about schemas.
I hava primary schema that have a table that my system insert it's data into it.
My need is a mechanism for deleting out of date records from mentioned table to another table in another schema that is in second databas system.
Please Help Me if you have any idea
[Updated on: Sat, 10 November 2007 06:32] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
