VB & Concurrent users

[abhi_v]

Hi All,
I would like to know how well will VB 6.0 handle a situation wherein hundreds/thousands of concurrent users try to access the same field of the same record of the same table of the same database. Database could be SQL Server / Oracle
Does the concurrency control feature of the RDBMS take care of this situation?

Plz help at the earliest


Abhi_V

[Pino]

to my knowledge most databases have a system inplace to stop this happenign they 'line up' the requests then process each (to my knowledge)

although if you are developing it as a server in vb you could just do a request wait next wait etc

[abhi_v]

Hi Pino,
Thanks for the reply. That is true that RDBMS have concurrency control, but are they proven to be efficient in the same. I am asking this because i am in a situation where I can't loose even a single concurrent attempt.
In the case that i posted earlier if concurrency control resolves the problem then do you think that servicing all the concurrent users will then require good amount of time or will be dependant on the hardware configuration as well. What if I use a robust configuration with a few gigs of RAM.
Plz help, thanks


Abhi_V

[RobDog888]

Welcome to the Forums abhi_v.

The larger RDBMS db servers take care of this for you. It is called
a deadlock when two or more requests are made at the same
time on the same record. It order to reduce deadlocks you try to
fine tune your record/table locks as fine as you can. With SQL
Server I cant remember correctly but I think you can specify how
SQL is to handle the loosing request.

[abhi_v]

Thanks Rob,
Any idea on how a j2ee app can communicate with an MS (VB or VC) code. I have some more queries which i should post by the end of the day. Thanks.


Abhi_V