November 27, 2009 at 10:45 pm
I have to run multiple queries (about 100 queries) for generate a report.I want to run multiple queries in a single database connection because if i run every query separately.then for each query,database will be connected separately.that will be extra load on database.Please guide me hoew to run multiple queries at a time so that load can be reduced.
November 27, 2009 at 11:01 pm
Hi,
No need to connect the each DB separate to run the multiple DB procedures,
Just call the procedures with full qualification that is DB1.DBO.MYSP, DB2.DBO.MYSP2 like this you manage to executive the procedure with in the single DB.
November 27, 2009 at 11:27 pm
combined these 100 query in a single stored procedure.
and execute only one stored procedure from your application.
November 27, 2009 at 11:40 pm
raaz66 (11/27/2009)
if i run every query separately.then for each query,database will be connected separately.that will be extra load on database.
How you say the extra load on the DB?
raaz66 (11/27/2009)
combined these 100 query in a single stored procedure
If it is possible means,
Compile all other report DB procedure in your DB (single DB)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply