On Tuesday, 20 December 2016 11:35:49 UTC+13, Tomas Pospichal wrote: > > I have seen slow local network connections from Java on other platforms, > but with H2 it seems to be OSX or mac OS users who are running into it. > Similar problems have been discussed here last month: H2 database running > really slow on mac OS sierra > https://groups.google.com/d/msg/h2-database/H-oSOO7Lwn4/Pm5eY0WTBwAJ > Although the problem got resolved by a simple addition to the hosts file, > it is not quite clear what were all the things at play there and whether > your situation is the same. >
Certainly, changing the file doesn't appear to have made any difference. However, I still need to confirm whether caching is having an effect here i.e. whether my changes are actually being paid attention to. > In your case, you may want to first try to set the local host name > explicitly to something simple (no spaces, apostrophes or other > non-traditional characters), rather than relying on your system to somehow > automatically convert computer name to a legal network hostname. (The full > computer name can be kept as is, for use in the UI). > OK, I just set it to "trial.local" (by clicking Edit in the Sharing preference pane). etc/hosts now reads 127.0.0.1 localhost trial.local 255.255.255.255 broadcasthost ::1 localhost trial.local fe80::1%lo0 localhost And no improvement in speed.... But, again, maybe the system isn't even privy to those changes. > I am not sure why you try to add "-2" at the end of the presumed hostname > in your hosts file, the queries in your TCP captures do not show anything > like that. > Well, I did it because that's what the Sharing preference pane said was my local host name -- I found it a little strange, but that's what it said, so I used it. > Finally, if you had no luck seeing any effect from modifications to > /etc/hosts: on newer macs the file is apparently shadowed by > /private/etc/hosts > Yeah, I was being a bit lazy in typing etc/hosts. In fact etc is just an alias on my system, to private/etc. So it was in fact private/etc/hosts which I was editing. Thanks for the ideas, Tomas. Any others gratefully received! :-) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
