excel - Reduce time querying SQL table -


i have user form runs query , updates object in userform. every time user clicks button query rerun.

can open connection when initialize form don't have open each time user clicks button?
remove slight delay i'm getting after click?

thanks!

i think should use connection pool openned connections can reused


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

java - How to transfer data to another jsp -

i've built dynamic table has add button (that adds new row), delete button (deletes rows) , submit. i wanna take information in table (i don't know how many rows user add) , process @ other jsp page. this have far: <script type="text/javascript"> var cb=new array(); var fn=new array(); var ln=new array(); var email=new array(); var i=1; function addrow(tableid){ var table=document.getelementbyid(tableid); var rowcount=table.rows.length; var row=table.insertrow(rowcount); var cell= row.insertcell(0); var element=document.createelement("input"); element.type="checkbox"; element.name="cb"+i+""; cell.appendchild(element); var cell1=row.in...
Read more