number of connections

number of connections

Post by Zb » Wed, 01 Oct 2003 04:28:22


Hello,

why my ADP application makes more than one simultaneous
connections to SQL server? Is there any way to control
maximal number of connections being created?

I use Access 2000 and MSDE.

Thanks,
Zb.
 
 
 

number of connections

Post by Mary Chipm » Thu, 02 Oct 2003 04:43:43

The why of it is so that processing is not done serially. For example,
if your form has 3 bound combo boxes, then when the form opens, four
queries are running simultaneously. If the result sets are large, then
running them serially on a single connection would take a long time,
and performance would be unacceptable. With MSDE you have a
performance throttle with 5 concurrent batches, so you'll want to code
your app accordingly. IOW, fetch only needed data and stay away from
large result sets.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.yqcomputer.com/

 
 
 

number of connections

Post by Zb. » Fri, 03 Oct 2003 07:11:24

Thank you Mary.
It seems that I have no chance to force the Access to do
it serially... Good MS strategy to force me to buy full
SQL :).
Thanks once more.
Zbynek.

For example, >>if your form has 3 bound combo boxes, then when the form
opens, four >>queries are running simultaneously. If the result sets
are large, then >>running them serially on a single connection would take a
long time, >>and performance would be unacceptable. With MSDE you have
a >>performance throttle with 5 concurrent batches, so you'll
want to code >>your app accordingly. IOW, fetch only needed data and
stay away from >>large result sets. >> >>-- Mary >>Microsoft Access Developer's Guide to SQL Server >> http://www.yqcomputer.com/ >> >>On Mon, 29 Sep 2003 12:28:22 -0700, "Zb"
>> >>>Hello, >>> >>>why my ADP application makes more than one simultaneous >>>connections to SQL server? Is there any way to control >>>maximal number of connections being created? >>> >>>I use Access 2000 and MSDE. >>> >>>Thanks, >>>Zb. >> >>. >>
 
 
 

number of connections

Post by Mary Chipm » Sat, 04 Oct 2003 11:23:12

You know, you *can* redesign the way your app fetches data and code
around this limitation.

-- Mary
MCW Technologies
http://www.yqcomputer.com/



>>> >>>>Hello, >>>> >>>>why my ADP application makes more than one simultaneous >>>>connections to SQL server? Is there any way to control >>>>maximal number of connections being created? >>>> >>>>I use Access 2000 and MSDE. >>>> >>>>Thanks, >>>>Zb. >>> >>>. >>>