Opening a new connection takes time in GUI

[cebaa]

Among other things, looks like opening a new connection takes a lot of time in the GUI. Here's a snap of AWT thread. This is the capture only for the time before opening the new connection till the "Connecting..." dialog disappears. It takes more than 2 seconds for that to happen. Some of it is looks like GUI-related only, so might be something worth taking a look:

"AWT-EventQueue-1","3,098 ms (-0%)","917 ms (-0%)","3"
" java.awt.EventDispatchThread.run ()","3,098 ms (-0%)","917 ms (-0%)","3"
"  java.awt.EventDispatchThread.pumpEvents ()","3,098 ms (-0%)","917 ms (-0%)","3"
"   java.awt.EventDispatchThread.pumpEvents ()","3,098 ms (-0%)","917 ms (-0%)","3"
"    java.awt.EventDispatchThread.pumpEventsForHierarchy ()","3,098 ms (-0%)","917 ms (-0%)","3"
"     java.awt.EventDispatchThread.pumpEventsForFilter ()","3,098 ms (-0%)","917 ms (-0%)","3"
"      java.awt.EventDispatchThread.pumpOneEventForFilters ()","3,098 ms (-0%)","917 ms (-0%)","3"
"       net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent ()","3,098 ms (-0%)","917 ms (-0%)","3"
"        java.awt.EventQueue.dispatchEvent ()","3,098 ms (-0%)","917 ms (-0%)","3"
"         java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege ()","2,796 ms (-0%)","615 ms (-0%)","1"
"          java.security.AccessController.doPrivileged ()","2,796 ms (-0%)","615 ms (-0%)","1"
"           java.security.AccessController.executePrivileged ()","2,796 ms (-0%)","615 ms (-0%)","1"
"            java.awt.EventQueue$4.run ()","2,796 ms (-0%)","615 ms (-0%)","1"
"             java.awt.EventQueue$4.run ()","2,796 ms (-0%)","615 ms (-0%)","1"
"              java.awt.EventQueue.dispatchEventImpl ()","2,796 ms (-0%)","615 ms (-0%)","1"
"               java.awt.event.InvocationEvent.dispatch ()","2,796 ms (-0%)","615 ms (-0%)","1"
"                net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrameHandler$$Lambda$374.0x00000008013038b0.run ()","2,390 ms (-0%)","315 ms (-0%)","1"
"                 net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrameHandler.lambda$createSession$1 ()","2,390 ms (-0%)","315 ms (-0%)","1"
"                  net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrameHandler.createSessionFrame ()","2,390 ms (-0%)","315 ms (-0%)","1"
"                   net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame ()","2,390 ms (-0%)","315 ms (-0%)","1"
"                    net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init> ()","1,394 ms (-0%)","118 ms (-0%)","1"
"                     net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI ()","1,394 ms (-0%)","118 ms (-0%)","1"
"                      net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.initialize ()","1,394 ms (-0%)","118 ms (-0%)","1"
"                       net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI ()","1,090 ms (-0%)","118 ms (-0%)","1"
"                        net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init> ()","1,090 ms (-0%)","118 ms (-0%)","1"
"                         net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab ()","1,090 ms (-0%)","118 ms (-0%)","2"
"                          net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.BaseSQLTab.getComponent ()","972 ms (-0%)","0.0 ms (0%)","1"
"                           net.sourceforge.squirrel_sql.client.session.mainpanel.sqltab.SQLTab.createSqlPanel ()","972 ms (-0%)","0.0 ms (0%)","1"
"                            net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                             net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                              net.sourceforge.squirrel_sql.client.session.filemanager.FileHandler.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                               net.sourceforge.squirrel_sql.client.session.filemanager.FileManagementCore.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                                net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                                 net.sourceforge.squirrel_sql.client.session.filemanager.FileChooserManager.initNewFileChooser ()","972 ms (-0%)","0.0 ms (0%)","1"
"                                  javax.swing.JFileChooser.<init> ()","972 ms (-0%)","0.0 ms (0%)","1"
"                                   javax.swing.JFileChooser.<init> ()","493 ms (-0%)","0.0 ms (0%)","2"
"                                    javax.swing.JFileChooser.setCurrentDirectory ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                     java.awt.Component.firePropertyChange ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                      java.beans.PropertyChangeSupport.firePropertyChange ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                       java.beans.PropertyChangeSupport.firePropertyChange ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                        java.beans.PropertyChangeSupport.fire ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                         javax.swing.plaf.metal.MetalFileChooserUI$5.propertyChange ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                          javax.swing.plaf.metal.MetalFileChooserUI.doDirectoryChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                           javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxModel.addItem ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                            javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxModel.setSelectedItem ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                             javax.swing.AbstractListModel.fireContentsChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                              javax.swing.JComboBox.contentsChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                               javax.swing.JComboBox.selectedItemChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                javax.swing.JComboBox.fireItemStateChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                 javax.swing.plaf.basic.BasicComboPopup$Handler.itemStateChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                  javax.swing.plaf.basic.BasicComboPopup.setListSelection ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                   javax.swing.JList.setSelectedIndex ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                    javax.swing.DefaultListSelectionModel.setSelectionInterval ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                     javax.swing.DefaultListSelectionModel.changeSelection ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                      javax.swing.DefaultListSelectionModel.changeSelection ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                       javax.swing.DefaultListSelectionModel.fireValueChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                        javax.swing.DefaultListSelectionModel.fireValueChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                         javax.swing.DefaultListSelectionModel.fireValueChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                          com.formdev.flatlaf.ui.FlatListUI$$Lambda$221.0x0000000801180c78.valueChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                           com.formdev.flatlaf.ui.FlatListUI.lambda$createListSelectionListener$2 ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                            javax.swing.plaf.basic.BasicListUI$Handler.valueChanged ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                             javax.swing.plaf.basic.BasicListUI.maybeUpdateLayoutState ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                              javax.swing.plaf.basic.BasicListUI.updateLayoutState ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                               com.formdev.flatlaf.ui.FlatComboBoxUI$FlatComboPopup$PopupListCellRenderer.getListCellRendererComponent ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                                javax.swing.plaf.metal.MetalFileChooserUI$DirectoryComboBoxRenderer.getListCellRendererComponent ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                                 javax.swing.JFileChooser.getIcon ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                                  com.formdev.flatlaf.ui.FlatFileChooserUI$FlatFileView.getIcon ()","399 ms (-0%)","0.0 ms (0%)","1"
"                                                                   javax.swing.filechooser.FileSystemView.getSystemIcon ()","399 ms (-0%)","0.0 ms (0%)","1"

[gerdwagner]

Sorry, I can't reproduce your problem. Here are two things you could try.

1. Write a simple Java program which measures how long connecting to your database takes. I.e how long calling java.sql.DriverManager#getConnection(...) takes.

2. Go to menu File --> Global Preferences --> tab General and see if "Show Session startup hint" is checked. This will let you know if loading your DBs schema data takes longer than 3 seconds. If so you may consider reducing the schemas you load or whether you'd prefer to cache schema data locally.