----I posted this in the old forums by mistake.---- I am using JDBC in some google apps script functions to verify data in a google spreadsheet with an external mysql database. as you may imagine, starting a new JDBC connection every time I want to use a function to check data is slow.
my solution so far has been to create the connection as a global variable. this actually works (everything SEEMS much faster) BUT the custom menu items I added in onOpen disappear. is there a better way to do this? i must add... if I comment out the JDBC global variable before I open the spreadsheet, my custom menus load up as they should. Then, if I keep the ss open and reactivate the global variable (remove //), everything works the way I want it to. Or, at least, it SEEMS like it works the way I want it to.
