Maximum simultaneous connections foxpro 7 database

[elise111]

Hi,

Does anyone have an idea of how many simultaneous connections can be made to a foxpro database?
I've found an article that claims maximum 50 users and one with states it's unlimited, which one is correct?

Thanks in advance
Elise

 

[Mike Lewis]

Elise,

I've never heard of a limit of 50. In fact, I've never heard of any particular limit I would assume it is limited by resources and network capacity.

By the way, are you talking about accessing the VFP database engine natively through VFP itself, or from some other client, via ODBC?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[elise111]

hi Mike,

I am talking about accessing the VFP database natively.

Elise

 

[JRB-Bldr]

Was the "article that claims maximum 50 users" written by someone attempting to cast doubt on VFP and/or wanting to promote another database environment?

Since way back in the FPW days it was not too unusual for us to have clients with applications working for 100's or 1000's of users. Obviously not ALL of those users would be concurrent users, but I can guarantee that it would typically have been over 50.

I seriously doubt that VFP has downgraded its concurrent user limits since the FPW days.

Good Luck,
JRB-Bldr

 

[Mike Lewis]

Elise,

I think JRB-Bldr is right. I know that there are applications running today that regularly have more than 50 simultaneous users.

Do you happen to have a reference to the article you mentioned?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[rgbean]

The very first entry in the table at

http://www.universalthread.com/wconnect/wc.dll?FournierTransformation~4,3,1

claims they've had a 1,000 concurrent users. And the last one says 6,400!

Rick

 

[DSummZZZ]

I would assume it is limited by resources and network capacity.

I concur.
There is nothing 'embedded' within the VFP tables themselves to track users. Therefore, VFP or the table itself has no clue as to how many users are connected to that file. It is an OS or Network OS limitation. The number of physical connections is limited to the number of user licenses for the server.
The number of realistic connections is limited of course, only by the hardware and software (and programmer's abilities to use them all optimally ).


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[elise111]

hi,

the article that claimed 50 users can be found through the following link:

http://www.rtp.com/rtpcorpbase/PDFs/SQL_vs_FoxPro.pdf

But I'm reassured now that it's not that limited!!

Thanks to everyone who replyed

Greetings
Elise

 

[Mike Lewis]

Elsie,

The article actually said:

Visual FoxPro is an adequate database for small networks with the average number of user around 50.

Strictly speaking, that's correct. But an average is not the same as a maximum, and, in any case, just because it is 'adequate' for that number doesn't mean that it limited to that number.

The fact that the article is un-signed and un-dated should also raise a question mark.

Anyway, I'm pleased this thread has reassured you. If you have further issues re Visual Foxpro, be sure to stop by again.

Mike

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com