reontareha
asked on
what database best for simultaneous editing from remote users using citrix
What database should i use?
The size of the database I think is small. Please correct me where im wrong. Maybe a hundred projects. Employees around 2000.
Hundreds of employees must be able to read information from the database simultaneously.
Maybe up to 50 to use the database simultaneously for editing, deleting and creating records.
They currently are using Metaframe Citrix for all remote users (knowledge on how this program works will also be helpful)
Also, what tools would i need to design and test before implementing into their system? I currently have VB .NET 2003 and Macromedia 8.
This project is very important to me and your knowledge is appreciated. Thankyou.
The size of the database I think is small. Please correct me where im wrong. Maybe a hundred projects. Employees around 2000.
Hundreds of employees must be able to read information from the database simultaneously.
Maybe up to 50 to use the database simultaneously for editing, deleting and creating records.
They currently are using Metaframe Citrix for all remote users (knowledge on how this program works will also be helpful)
Also, what tools would i need to design and test before implementing into their system? I currently have VB .NET 2003 and Macromedia 8.
This project is very important to me and your knowledge is appreciated. Thankyou.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oracle has more granular record locking control than MS SQL, which can be handy with large numbers of users doing concurrent updates. Although, Oracle doesn't appear to have any better deadlock mitigation in my experience. IOW, you have to do the work in design in order to reap the rewards with Oracle. For the number of concurrent users and the DB size, I'll bet that MS SQL will work fine.
I can't see that having Citrix Metaframe clients would have any impact on the DB choice.
If it's a commerical application that is planned to be used, then it's best to go with whatever OS and DB the vendor uses as their primary build and test environment. That combo will always get the most love from the vendor.
Without knowing more about the application you're running, I couldn't comment on integration.
I can't see that having Citrix Metaframe clients would have any impact on the DB choice.
If it's a commerical application that is planned to be used, then it's best to go with whatever OS and DB the vendor uses as their primary build and test environment. That combo will always get the most love from the vendor.
Without knowing more about the application you're running, I couldn't comment on integration.
ASKER
i agree that MS SQL and Oracle will more than do the job. However, I feel mySQL will do just the job. There is less support but it can get the job done and it is much more cost efficient. Aaron was the only one who mentioned mySQL so i will give the points to him. Thankyou.
I am curious about what 'AaronAbend' is saying about SQL Server - it does have a varied locking model and performance is all about tweaking the server: So 'optimistic' locking is available but there are others too and it has row-level locking so a carefully designed application should not suffer from these issues - it's all about design.
I have no doubt that DB2 and Oracle are better than SQL Server in a production environment but remember that a database can be designed and tuned for concurrency and performance so that should play a major part in any considerations.