Open Data Base Efficiency/Run Time

[#1]

Hello,

When you use Open Database() it opens the database and runs the query. Well, when you need to run multiple queries on the same database does it hinder run time performance?

When I run local queries the run time is super quick every time. However,
when I run several queries on JMP with Open DataBase() I seem to get mixed results. I'm thinking I may be losing performance by reconnecting to the db over and over.

Is there a way to stay connected to the db and pass in queries?

for(i=1, i<=N Items(query_list), i++,
Open DataBase(server, query_list[i], "foo");
wait(1);
);

[#2]

I would suggest using New SQL Query() instead of other methods (Which way to go query database? ). It is the most complicated one and has lacking documentation (in my opinion) but it is still the way which will be getting enhancements.

[#3]

New SQL Query can run multiple queries simultaneously, if you use the <<Run Background message.

And you can keep it simple by using Custom SQL.

For Each( {v, i}, queries,
			New SQL Query(
				Connection( constring ),
				Custom SQL(
					"SELECT Col1, Col2
 FROM Table1
 WHERE Col1 = 'Good Data'"
				),
				Query Name( v || " contents" )
			) << Run Background(
				On Error( Print( "Huh.  Didn't work." ) ),
				On Run Complete( dt = QueryResult...... )
			)
		)
	)
);