MongoDB VS Intersystems Cache Part 1 insert performance

While looking through stackoverflow I noticed an interesting question about the differences between Intersystems Cache and MongoDB.

Now these databases are substantially different in many respects, but both do allow for a more direct object mapping approach than you will normally experience in a standard SQL environment. Having read that MongoDB had recently secured $150M in financing I was curious as to what the platform was like.

Picking a database is never just about raw performance, but it is one of the most important aspects so I thought I would start with this aspect.

What I thought would be interesting would be to compare the insert performance of objects in Intersystems Cache VS the insert performance in MongoDB.

I took a very simple example, inserting 10,000 objects each with 3 properties, performed both tests 3 times on my laptop and averaged the results. There were no indexes defined. This is not exactly a great test but as Cache was significantly faster at doing this than MSSQL and MySQL in previous tests I thought I would be a good first look.

MongoDB - 0.436 seconds
Intersystems - 0.445 seconds

I then followed this up with a slightly larger 1,000,000 records.

MongoDB - 39.925 seconds
Intersystems - 43.445 seconds

Looks like they manage similar performance in respect to database inserts.

In part 2 I will look into query performance and more fundamental differences between the two NoSQL databases.


Popular posts from this blog

IE9 Intranet compatibility mode in Intranet websites

Multi-select with shift on HTML table

Intersystems Caché performance, woe is me...