Jump to content

Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Toggle shoutbox Shoutbox Open the Shoutbox in a popup

@  styleseye : (24 April 2014 - 02:29 PM) Https://www.facebook.com/l.php?u=Https://www.youtube.com/watch?v=Geh4Rs-Boh8&feature=Youtu.be&h=Taqexxpem
@  styleseye : (24 April 2014 - 02:28 PM) Https://www.facebook.com/l.php?u=Https://www.youtube.com/watch?v=Geh4Rs-Boh8&feature=Youtu.be&h=Taqexxpem
@  yordan : (21 April 2014 - 09:11 PM) Hey, Ritesh, Did You Hear Me?
@  yordan : (14 April 2014 - 05:28 PM) By The Way, This Could Be An Interesting Subject For A Topic, What About Posting This Question? Let's See If Other People Have The Same Feeling Concerning Bootlists!
@  yordan : (13 April 2014 - 09:36 AM) Boot Order : Cd, [Usb,] Hard Drive :D
@  yordan : (11 April 2014 - 07:23 PM) I Simply Let The Bios Do That
@  Ritesh : (11 April 2014 - 10:23 AM) Is It Possible To Launch Fedora Live Cd Or Installation Disk From Hard Drive On Windows Platform Using Grub Mbr File.
@  Ritesh : (11 April 2014 - 10:21 AM) No U Are Not.. Btw.. I Have Question For You.
@  yordan : (10 April 2014 - 08:02 AM) You Are Partially Right.
I Was Not.
Nevertheless, I Am Again :)
@  Ritesh : (09 April 2014 - 07:33 PM) :P
@  Ritesh : (09 April 2014 - 07:33 PM) I Think U R Not..
@  yordan : (09 April 2014 - 09:28 AM) I'm The Master Of The Shoutbox!
@  yordan : (05 April 2014 - 10:32 PM) He-He
@  Ritesh : (04 April 2014 - 06:59 PM) Ha Ha Ha ....
@  yordan : (04 April 2014 - 11:15 AM) Welcome Back, Starscream!
@  yordan : (03 April 2014 - 02:31 PM) And I Hope That He Will Come Back Soon :)
@  yordan : (01 April 2014 - 02:53 PM) Nice, Ritesh Came, I'm Not Home Alone Today.
@  Ritesh : (01 April 2014 - 08:51 AM) Oh!!! Poor Dear Yordan..
@  yordan : (31 March 2014 - 10:02 AM) I'm A Poor Lonesome Cow-Boy
@  yordan : (27 March 2014 - 02:22 PM) He Is Unpatient Due To His Patients!

- - - - -

Best Performance Databases From Not-so-far Future (published By Parts) MMDBs, executable SQLs and all-all-all

1 reply to this topic

#1 rnd-am


    Newbie [ Level 2 ]

  • Members
  • 13 posts

Posted 18 December 2008 - 03:44 AM

Part I

Some time ago I was acquainted with one very fast bussiness-critical web-server application, and I became very interested, - how does this site work, outperforming fastest GUI applications?

And what was told to me.

Design has to met with very tight requirements for performance of system: simply to be the most powerful solution by performance, given that it should run on ordinar server equipment.

The guys who get this proposal owned some parts of this technology, so they brought up their components, and voila -solution is ready! They used their own ready web-server engine, and it was entirely been written using C++/STL and keeps all the data in memory.

For extendability it used plugins mechanism in fact, it was one resembling something like CGI for plugins.

Not only the web-server, which is not, may be much surprisingly, been written using C++, but also its database system, was designed for better performance using C++ and keeps all its data, as I said, in RAM.

That's all good, but now I'm thinking, what if...

It was - and is  - a system designed for best possible performance, but it yet has one weak point.

 - People, more exactly, Programmer, who designed and developed the entire system, was used C++ for it, and he has written every one of dozens of SQL requests by hands, using STL containers of C++. And when at some time he will express the desire and leave the project, he will leave it in unmaintainable state: system, supported by not so skilly personnel couldn't be possible to answer customer (frequently growing) needs, and would be in the best case only keeped in running in as-was state...

What was the main problem of it?

I think that it wasn't used wide spread (mainstream) components to build a such bright and very fascinating technology, reinventing the wheel, saying so. Moreover, most of available tecnologies are open source, if not all.

The technology stack of bricks could be:

1. Database: any database which keeps its data in and operates on RAM, i.e. MMDB, In-memory database,

    RAM nowadays becames so cheap, and people not yet accounted that fact and not yet widely using such DBs

These databases have certailny their SQL too, but that is not the best performance Database case, we should use compiled to native executable code database.

2. Bussiness-logic level language: There are available native code compilers for most scripting languages, so it could be written on PHP, for example, or PERL, or Python, and compiled to executable, which runs ten times faster.

3. Fast, lightweigh and very stable Web-server, written preferrably on C/C++

4. And the last brick to close the circle should be the SQL-to-native code compiler, the thinner place for now.

To be continued...

#2 Guest_(G)storm_*

  • Guests

Posted 30 May 2010 - 10:46 AM

Databases Benchmark SoftwareBest Performance Databases From Not-so-far Future (published By Parts)

Hi,We have created an open source benchmark project at http://sourceforge.N...ects/benchmark/ that includes some of the most widespread databases:- STSdb- Oracle Berkeley DB- Perst- MySQL (server)- MS SQL Server CE- Access- HamsterDB- SQLite- Db4objects- Firebird- H2.We accept proposals from Db4objects community to improve test results.

Reply to this topic


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users