12 Mar
2012
12 Mar
'12
11:53 p.m.
On 13-03-12 00:47, Joseph Brower wrote:
Thanks for all of the help! I think I'm beginning to understand. My concern is that it seems I can't be inserting every 1 minute like we are currently. We want to keep things up to date on a per minute basis.
Actually you can, I am inserting records per second, but at very high transaction overhead costs. If you solve it with: Start Transaction; COPY INTO; or INSERT; Commit; You might get away with that. But indeed, if you want to synchronise two systems, it is much better to create these copy into files. And stream them to the foreign host. Stefan