what is different from MSSQL, MYSQL and Oracle 11g?

15 pts.
Tags:
MSSQL
MySQL
Oracle 11g Database
what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    68,470 pointsBadges:
    report
  • Juna0606
    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?
    15 pointsBadges:
    report
  • HaterSaurusRex
    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.
    85 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following