Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Capacity of Paradox
- Thread starter Daniaa
- Start date
Daniaa,
Actually, Otto's understating the concurrent user limit. BDE is documented as supporting up to 300 simultaneous users, though I've seen it handle 650 simultaneous connections. You need to make sure that the server network is properly configured and that there are no bottlenecks, but it can be done.
This is fine for most workgroup or departmental applications, or even company-wide applications for organizations with less than 1000 employees. However, if you're thinking along the lines of a web-based database that will support more than 500 concurrent connections, you really need to consider a remote database server, such as InterBase, Progress, Oracle, Sybase, etc.
Local database formats (Paradox, dBASE, Access, etc) are best used with smaller user loads.
Also, keep in mind that there's a difference between number of potential users and those actually using it at any given time.
If you're using Delphi 5, you'll want to learn the new ClientDataSet and other Midas-related components. If you're using an older version, you may wish to consider upgrading as Delphi 5 (and the soon to be released Delphi 6) provide much better (read: easier to implement) support for distributed data.
Hope this helps...
-- Lance
Actually, Otto's understating the concurrent user limit. BDE is documented as supporting up to 300 simultaneous users, though I've seen it handle 650 simultaneous connections. You need to make sure that the server network is properly configured and that there are no bottlenecks, but it can be done.
This is fine for most workgroup or departmental applications, or even company-wide applications for organizations with less than 1000 employees. However, if you're thinking along the lines of a web-based database that will support more than 500 concurrent connections, you really need to consider a remote database server, such as InterBase, Progress, Oracle, Sybase, etc.
Local database formats (Paradox, dBASE, Access, etc) are best used with smaller user loads.
Also, keep in mind that there's a difference between number of potential users and those actually using it at any given time.
If you're using Delphi 5, you'll want to learn the new ClientDataSet and other Midas-related components. If you're using an older version, you may wish to consider upgrading as Delphi 5 (and the soon to be released Delphi 6) provide much better (read: easier to implement) support for distributed data.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Question
- Locked
- Question