Home  /  RSS  /  RSS Comments  /  Enter

Is Data Base the Bottle Neck of Web Service?

Saturday, April 11, 2009, by artyom ; 6 comments

One of most common knowledge of many web developers is the assumption the data base is the bottle neck of their web services. Indeed, if the search in the database takes O(\log n), it is probably the one that should take most of the time because most of other processing should take O(1).

However, the complexity theory tells one important thing... n should should be sufficiently big. How much is that? 1GB, 1,000GB, 1,000,000GB or even more?

So let's take as an example on of the biggest web projects: Wikipedia, or Wikimedia's Server Farm.

The facts:

So, how the SQL servers can be the bottle neck of the system when they are about less then 10% of the server farm? Assuming balanced system, it is obvious that Apache and PHP consume most of computation resources of WikiMedia server farm.

So:

Is Data Base is the Bottle Neck of Web Service?

Definitly not.

Would switch to CppCMS server side technology would improve the performance

Definitly yes.

Comments

Ian, at 5/30/09 7:52 PM

Might maybe gain more supporters if you were more definite instead of defiant. :)

artyom, at 5/30/09 7:58 PM

Might maybe gain more supporters if you were more definite instead of defiant. :)

Thanks, Fixed...

Bhushan, at 1/8/10 7:10 AM

May be u r right? But what about the C++ database wrappers u r providing? I suppose that php virtually requires less than 20% coding when compared with plain C++. I am a certain supporter of C++. Does your cppCMS provide anything better than what is currently available for C++ developers with MySQL?

artyom, at 1/9/10 10:24 PM

Does your cppCMS provide anything better than what is currently available for C++ developers with MySQL?

CppCMS is web orineted and not ORM oriented, at this point there are lots of tools for working with SQL... So any database is relevant.

Also, CppCMS provides very powerful caching system allowing reduce number of SQL queries... Making lower loads on DB.

I suppose that php virtually requires less than 20% coding when compared with plain C++.

When you use CppCMS you have all tools to write good web applications, so same code in PHP or written with CppCMS in C++ would be much simpler in C++ because CppCMS is full MVC framework, when PHP is not.

Michael, at 10/31/11 11:10 AM

a few months ago I wrote a few cgi's (simple old school cgi - not fastcgi, etc) in c and yes people did think I was crazy but the speed was astonishing!

it left everything else for dead!

I will download CppCMS and give it a try - It might save me some time re-inventing the wheel! (and will help me become more familiar with c++ concepts - which would be useful for some offline projects I have in mind too)

Roy Owor, at 3/14/13 5:21 PM

Notice Staff will be giving in a try for a service project am working on. and compare it to an existing php service already running

Add Comment:

 
 the email would not displayed
 

You can write your messages using Markdown syntax.

You must enable JavaScript in order to post comments.

Pages

Categories