| Title: | Microsoft Visual Basic |
| Moderator: | TAMARA::DFEDOR::fedor |
| Created: | Thu May 02 1991 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2565 |
| Total number of notes: | 10453 |
Have to ask this though I think its impossible.
We are been asked if anybody knows a customer who have..wait for it..
1000 VB (one thousand) clients hitting a SQLserver database in 2 tier mode.
(I know the amount of concurrent users would be a factor..I believe it
would be high)
I think it such a scenario you would need a TP monitor to handle this.
Any comments
rgs
mick
Also posted in SQLserver conference
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2504.1 | ELIS::TOWERS | Mon Feb 24 1997 04:17 | 18 | ||
Mick, you could try mailing John Walker (@RTO or @FKR) or John Whelan
(UNTADE::WHELAN, not sure if he has an all-in-one). John Walker was my
boss and John Whelan was his partner, when I worked on RCW. At the time
the largest implementation had 50-100 VB clients talking to a SQLServer
db. Since then RCW is supposed to have been implemented European-wide.
If the UK has implemented it then I would imagine the number of VB4
clients would be around your ballpark figure.
Note that the main concern the users had was performance (big surprise
there!) but that performance problems arose as much as anything from
the amount of data being accessed (db was about 500 MB) as from the
number of clients. Be sure to have the server stuff running on a big
beefy Alpha with plenty of scope for upgrade of memory and number of
processors. More memory (after you'd made sure the db structure is
optimised) is the best/easiest way of improving performance.
Cheers,
Brian
| |||||
| 2504.2 | Interesting | SIOG::KEYES | Digital Appliation Gen. DTN 827-2705 | Mon Feb 24 1997 05:18 | 13 |
HI There Brian,
Interesting. I will certainly try and contact those folk. Performance
was certainly the first issue that came to mind. hence we were leaning
towards a more 3 tier scenario (Ole based) or with a TP monitor
like Acmsxp on NT. I take your point though about a big focus on
optimized design of the database..
will drop a note back here if we get any luck or what is decided...
rgs and thanks
Mick
| |||||