So right now we're only doing a COPY INTO; . Would there be a positive impact to doing the Start Transaction; first? Also, how would I configure MonetDB to balance those connections? Is that something I'd need to do at the client level or is it possible to have a single "master" server the distributes that load down to the child nodes? Thanks, Joseph Brower On 03/12/2012 05:53 PM, Stefan de Konink 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
On 13-03-12 00:47, Joseph Brower wrote: 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
------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users