what is different from MSSQL, MYSQL and Oracle 11g?
what is different from MSSQL, MYSQL and Oracle 11g?
Which one is the best for 15000 transaction daily?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 15, 2010 2:55 PM
UPDATED:
January 17, 2010 3:47 AM
Answer Wiki:
Each one has there own slightly different quirks to the SQL language, and they all have slightly different ways of doing things.
15k transactions a day is nothing. Any of those three solutions can handle that workload without issue. Assuming that your workload would all happen within an 8 hour time frame, that is 1875 transactions per hour, or 31 transaction per minute.
To see all answers submitted to the Answer Wiki: View Answer History.
As stated above, any of the 3 options would handle that workload well. Other factors (such as operating system, budget, growing expectations, etc, etc) would need to be considered to decide which one is better for you.
Thank you for all reply!
The system needs to be handled daily operation, transfer the information for management to make decision and strategic planning.
Which is the best?
All three have reporting tools available, and if all 3 are capable of handling the workload, then the deciding factors will come down to:
1. Budget – Oracle 11g and MS SQL Server could be very costly, MySQL is free.
2. Familiarity – Do you have any Linux admins in your environment? If so the learning curve for Oracle on Linux or MySQL will be much shallower. If you’re an all Windows house, MS SQL on Windows Server will be much more user friendly.