top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Which is faster MangoDb or MySQL?

+3 votes
113 views
Which is faster MangoDb or MySQL?
posted Jan 21, 2015 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In general answer is MongoDB , MongoD offers very good performance for situations containing very high write loads, but where data integrity isn’t a pressing concern.

Advantages of MongoDB over RDBMS
Schema less: MongoDB is document database in which one collection holds different different documents. Number of fields, content and size of the document can be differ from one document to another.
Structure of a single object is clear
No complex joins
Deep query-ability. MongoDB supports dynamic queries on documents using a document-based query language that's nearly as powerful as SQL
Ease of scale-outConversion / mapping of application objects to database objects not needed
Uses internal memory for storing the (windowed) working set, enabling faster access of data

But MongoDB is not magically faster. If you store the same data, organised in basically the same fashion, and access it exactly the same way, then you really shouldn't expect your results to be wildly different, because MySQL and MongoDB are both GPL.

answer Jul 5, 2015 by Salil Agrawal
Similar Questions
0 votes

I'm attempting to move away from PHP mysql functions to something newer, either mysqli or PDO.

I have read various things about them, but I'm curious at this point which would be best to learn for the present and future. I'm usually working on small to medium size projects.

I understand that PDO has an extra abstraction layer so it can work with / convert to other databases like oracle and others fairly easily, but some have said that PDO can be a bit slower the MySQLi?

So I would really like to hear opinions on the best choices of either MySQLi or PDO.

Also I'm also trying to learn OOP, so I'm looking for a very good working PDO and/or mysqli database class - to get started with, that has all the basic needs like UPDATE - INSERT - DELETE - QUERY etc. That would be very helpful.

+1 vote

We are running MongoDB 3.0 with wiredTiger storage engine and wiredTigerCacheSizeGB is 24.
Now, I want to increase the wiredTigerCacheSizeGB value from 24 to 32. Is it possible to increase this variable without restart the service ?

...