MemSQL Makers Say They've Created the Fastest Database On the Planet

mikejuk writes "Two former Facebook developers have created a new database that they say is the world's fastest and it is MySQL compatible. According to Eric Frenkiel and Nikita Shamgunov, MemSQL, the database they have developed over the past year, is thirty times faster than conventional disk-based databases. MemSQL has put together a video showing MySQL versus MemSQL carrying out a sequence of queries, in which MySQL performs at around 3,500 queries per second, while MemSQL achieves around 80,000 queries per second. The documentation says that MemSQL writes back to disk/SSD as soon as the transaction is acknowledged in memory, and that using a combination of write-ahead logging and snapshotting ensures your data is secure. There is a free version but so far how much a full version will cost isn't given." (See also this article at SlashBI.)

okay...?

[bhcompy]

When I think of fast databases to compare to, the first thing I think of is MySQL.

/Actually, I'd rather see a comparison to Pick or other lightning fast MV dbs

Facebook engineers? Gah!

[TheMiddleRoad]

I wouldn't run my toaster on software engineered by someone from Facebook, let alone a database. I'd have to spend ten minutes searching for my toast, and it would show up the following week.

Re:Facebook engineers? Gah!

[duk242]

And then the next week, your toast would have changed from white bread to wholegrain and you're just going to have to get used to it.

Re:okay...?

[LurkerXXX]

But with MySQL you can get a wrong answer REAL FAST!!!

Re:Bah - I had the SAME basic idea in 1996 onwards

[Anonymous Coward]

Windows NT Magazine (now Windows IT Pro) April 1997 "BACK OFFICE PERFORMANCE" issue, page 61

(&, for work done for EEC Systems/SuperSpeed.com on PAID CONTRACT (writing portions of their SuperCache program increasing its performance by up to 40% via my work) albeit, for their SuperDisk & HOW TO APPLY IT, took them to a finalist position @ MS Tech Ed, two years in a row 2000-2002, in its HARDEST CATEGORY: SQLServer Performance Enhancement).

This episode of "Tech Tips With Timecube Guy" brought to you by the letters W, T, and F, and by CapsCORP: If Bizarro Caps Are Your Thing, cALl uS!

Re:Show me vs a real DB engine

[Anonymous Coward]

PostgreSQL is definitely the best database software out there.

Re:Show me vs a real DB engine

[gman003]

Ah, but it's an "enterprise-grade" toy.

Re:Ya Don't Say!

[Paradise Pete]

I am a ramdisc fan since Mac+.

I'm gonna call BS on this one. Why would a ram disc need a fan?

Re:Ya Don't Say!

[Hognoxious]

MySQL is not webscale because it uses joins.