On Saturday, 17 December 2016 21:44:34 UTC+13, Noel Grandin wrote: > > > On 17 December 2016 at 09:42, SkiAddict <[email protected] <javascript:>> > wrote: > >> >> - I'm sorry, but can you please explain how to set a system property? >> I've googled java.net.preferIPv4Stack and all I see is Java code, calls to >> System.setProperty(). Also how do I get the current value of >> java.net.preferIPv4Stack -- perhaps it's already true??? >> > > add > -Djava.net.preferIPv4Stack=true > to the h2.sh file after the "java" command >
OK, thanks :-) I've downloaded 1.4.193 and am using the h2.sh file in the bin folder to launch the console now. I see that it calls org.h2.tools.Console, whereas my script file calls org.h2.tools.Server. I don't know where I got my script from -- I certainly didn't write it. Perhaps back in 2010 the h2.sh file called Server? In any case the timings are now different, but still very slow. Instead of just over 2 seconds to launch the console it takes 1m35s. Changing the preferIPv4Stack property makes matters worse -- launching takes 1m50s. > - I've downloaded wireshark just now and I've got a capture of launching >> the console. There are 25 gaps of 3 or 4 seconds (mostly 3 seconds) >> between lines -- I've never done network analysis before so I don't know if >> this (3s / 4s) is a long time, I'm assuming Yes. I've saved the file so >> can send in the (assuming unlikely) event you want to see it. There's a >> huge number of things called "Standard query 0x0000 <hard disk name>.local, >> "QU" [or "QM"] question AAA <hard disk name>" and then the text goes off >> the screen and I haven't figured out a way to see the rest of it. Many of >> the 3s / 4s gaps are between lines like this. >> > > you could post a screenshot here to look at > OK, here goes. This is of launching 1.4.193, without the change to preferIPv4Stack. Wireshark is the only other app running at launch time (not even browser or the Terminal). The timeline is as follows: - 0s launch h2.sh - 23s "Console" appears in my menu bar - 31s browser launched - 1m25s console finished loading in browser tab The first two screenshots show the time up to 31s and the third one shows the end of the entire process. The redactions are simply my name. I removed the two bottom panes since they only show information for the selected row, and it enabled me to show more rows in each shot. I also tried to show as much information on each row. <https://lh3.googleusercontent.com/-YPrL5MpWZHU/WFWuiOxFaYI/AAAAAAAAADU/Sg4xlq2dmeghTNN55QoVtfqv_PhalxdQACLcB/s1600/Capture%2B1.gif> > > <https://lh3.googleusercontent.com/-NUUfWaLWQWo/WFWu3-hPt7I/AAAAAAAAADY/x4aQZx9nzUcONfXNxqjaHpygAg8KTeS9wCLcB/s1600/Capture%2B2.gif> > <https://lh3.googleusercontent.com/-k_jT629V4AY/WFWvI7BGXaI/AAAAAAAAADc/WwDrRqHyxiUELEVWMhDt2HfGAlb-uy5JwCLcB/s1600/Capture%2B3.gif> <https://lh3.googleusercontent.com/-k_jT629V4AY/WFWvI7BGXaI/AAAAAAAAADc/WwDrRqHyxiUELEVWMhDt2HfGAlb-uy5JwCLcB/s1600/Capture%2B3.gif> <https://lh3.googleusercontent.com/-k_jT629V4AY/WFWvI7BGXaI/AAAAAAAAADc/WwDrRqHyxiUELEVWMhDt2HfGAlb-uy5JwCLcB/s1600/Capture%2B3.gif> <https://lh3.googleusercontent.com/-k_jT629V4AY/WFWvI7BGXaI/AAAAAAAAADc/WwDrRqHyxiUELEVWMhDt2HfGAlb-uy5JwCLcB/s1600/Capture%2B3.gif> > And I just noticed that you're running a really old version. > You should probably try the latest 1.4 release, and add MV_STORE=false to > your URL if you need to keep on using old databases. > I prefer not to use beta versions, but did try 1.3.176, and found it just as slow as 1.3.167, and in addition it gave me an error when it finally finished opening my database. So I figured I'd stick with 1.3.167 while fixing this slowness. But I'll certainly use 1.4.193 at least for the moment. Thanks again, Noel. I do appreciate your help. -- 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.
