What's the fastest way to run a lot of SELECT queries in JDBC with MySQL?

Question

I've done a lot surfing and have found contradictory/unclear answers. Suppose I have 100 SELECT queries that I'd like to run. None of the queries in any way depend on the others. The returned is relatively small (each ResultSet is only a few rows), so bandwidth isn't an issue. My DB is remote, so my biggest source of latency stems from round-trip-time.

Is there any way I can do this in a single RTT? What's the fastest way I can get all the results back?

take a look at this https://stackoverflow.com/a/10804730/15741634 — marac990, Apr 30 '21 at 02:06

score 0 · Answer 1 · answered May 01 '21 at 04:23

0

After some testing of all the alternatives I've come across, the fastest way to accomplish this (by far) is to create a stored procedure.

answered May 01 '21 at 04:23

Guy4444

79
8

What's the fastest way to run a lot of SELECT queries in JDBC with MySQL?

1 Answers1