On 13-03-2012 01:10:53 +0100, Stefan de Konink wrote:
On 13-03-12 01:00, Joseph Brower wrote:
So right now we're only doing a COPY INTO; . Would there be a positive impact to doing the Start Transaction; first?
If that is the only thing you do in a client connection, and then close it again: probably not.
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?
I don't have experience with non-naive implementation on that. Maybe some of the MonetDB researchers could comment on this.
monetdbd(1) allows amongst other things balancing per connection. See the "REMOTE DATABASES" section in the man-page [1]. Fabian [1] http://www.monetdb.org/Documentation/monetdbd-man-page