performance - When and How Does the Database Slow Down a Site? -

-

i have read book o'reilly states 70-80% of performance of site can optimized via front-end. may mean database queries may account less 20 or 30% of site's performance. however, have seen huge websites facebook , twitter dedicate time optimizing queries (via query caching, normalizations, etc). when database become critical site's performance can account more aforementioned percentage? oh, , performance mean in context of speed, loading speed in particular.

when database become critical site's performance can account more aforementioned percentage?

after have optimized front-end max, relative impact of back-end become larger.

also, big sites face problem of scalability. might able serve single user fast, load grows, gets slower everyone. client-side part spread across users' machines, scales well. back-end shared everyone, , become bottleneck.


Comments

Post a Comment

Popular posts from this blog

drupal - using views argument in the view tpl.php file -

-
i newby drupal. here problem: on main page.tpl.php have code lines: "if ( $is_front == true ) { print views_embed_view('all_product_by_type_thin', "default", "canon"); print views_embed_view('all_product_by_type_thin', "default", "nikon"); }" as can see, in case of front page print "all_product_by_type_thin" view while sending parameter "cannon" , "nikon" the result of all_product_by_type_thin view altered inside views-view-unformatted--all_product_by_type_thin.tpl.php file. in file wrapping view results in kind of divs. need though, , cant figure out way it, argument sent view "canon" or "nikon" inside php code of views-view-unformatted--all_product_by_type_thin.tpl.php idea ? inside views theme file ie. views-view-unformatted--all_product_by_type_thin.tpl.php should have access $view object. one of attributes of object contain arguments pass...
Read more

php - Posting PHPBB Forum Thread/Post info in a website -

-
i trying extract, say, latest/most recent 5 threads in x section of forums , have 'posted' on website link viewers can go directly thread instead of having browse forum or not. i've seen , read tutorials online but...in honesty, phpbb seems mess me. all appreciated g.campos if don't have access forum' db, might want try phpbb3 portal, such this one . however, if have access mysql(?) db, might want give shot select sentence, such as: select * phpbb_posts forum_id = x order post_time desc limit y"; change 'x' forum id want dump from, , 'y' post_time limit want stop dumping; having in mind facing strtotime times, such 1290886590 . then, execute query , fetch result ( mysql_fetch_array ) formatting on table or whatever want. play post_subject , other columns nice output. luck. edit: have pretty extensive tutorial on phpbb page, here . give look.
Read more

silverlight - Applying a style to ItemContainerStyle in C# -

-
when i'm applying style listbox.itemcontainerstyle in c# isn't making change @ runtime. i'm using; mylistbox.itemcontainerstyle = (style)(app.current.resources["newitemstyle"]); however other styles being supplied, such buttons etc i'm going mybutton.style = (style)(app.current.resources["mymainbuttonstyle"]); i don't errors either, nothing , reverts default system style. i using app.current.resources instead of resources because "newitemstyle" wasn't defined in whole application. mistake.
Read more