none
DBMS for huge data management RRS feed

  • Question

  • Hi there let me know which dbms (mysql, mssql,no sql,mongo db) is best to manage a huge database if I am working on PHP platform. It should pull the data as fast as possible as well as update, insert should be faster.


    Saturday, June 20, 2020 9:11 AM

All replies

  • I can speak for MS SQL Server as being capable of handling huge data. Oracle is another. Of course, you have to know what you are doing. If you do something stupid, then expect lack luster capability

    jchang

    Saturday, June 20, 2020 4:23 PM
  • Hi pranaliNG,

    This is a community forum for SQL Server technical questions & issues.

    SQL Server 2019 is the latest version of the versatile and venerable SQL Server. This latest version continues to redefine SQL Server from a traditional relational database system to a data platform for every data scenario from OLTP to DW to now big data and analytics.

    Check the Introducing the SQL Server 2019 video learning series  or  ebook Introducing Microsoft SQL Server 2019.

    Best Regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Fredrik Monday, June 22, 2020 6:04 AM
    Monday, June 22, 2020 3:30 AM
  • What do you mean by huge data? >100 GB? >2TB?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, June 22, 2020 3:59 AM
    Moderator
  • For PHP the usual combination is MySQL (although not necessary).

    One of my colleagues told me that MySQL is much faster than MS SQL (she told from her personal experience). I don't know if that's true or not, I only have very limited experience with MySQL and working with latest Workbench I found a couple of bugs while trying to import data.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles

    Monday, June 22, 2020 3:08 PM
    Moderator
  • There is no way to answer your question.  There are many database engines which do different things well.  Without knowing specifics about your actual data needs, it is impossible to give a recommendation.

    You just walked into a home improvement store and said "I need a saw".  There are hundreds of different kinds of saws used for specific purposes.  You don't use a table saw to cut down trees.  You don't use a chain saw to cut trim in your house.

    Monday, June 22, 2020 7:49 PM
    Answerer