Thursday, 11 May 2006
How I Learned to Love Tuning 
« iPod Ecosystem: iBuzz - musical orgasm machine | Main | Web 2.0 Traffic Breakdown: Machines vs. Humans »
Exactly a week ago I posted about the recent performance improvements I made with Simpy. That's the green ellipse in the picture on the lft. People noticed the improved page load times and sent nice email. Needless to say, I was pretty happy. Then, all of a sudden, things again went down hill. That's the red circle in the picture. I starred at the database server for a while, and finally found a veerrry sloooowwwww querrrry. It turned out the query was not using the index it should have been making use of. Why not? Thanks to the fast and superb support found in the open-source community, I got help from database experts who quickly pointed me in the right direction. It turned out some of the statistics that the database server normally gathers was off by a large number. After I made the appropriate change, the database server load decreased by several orders of magnitude, as you can see in the picture below.
The sudden drop in the chart represents the sudden drop of the load on the server. Of course, this nirvana won't last forever, and there will be new hurdles to jump over. That's just the nature of the beast. Until then, I'll be enjoying the speedier Simpy. As always, if you notice consistent slowness on any portion of the site, please let me know.
Posted by at 5:06 PM in /

Comments on this entry:
Respect to the great database expert!
I wish I'd have this knowledge.
Don't you tell us which database the mentioned part runs on?
Philipp:
The exact database information is unimportant. The same principles apply to MySQL, PostgreSQL, Oracle, Sybase, etc.
Otis:
Sorry for asking the obvious but where in Simpy were the improvements seen by the denizens?
In my opinion, the tardiness of Add Link lately has been quite a pain in the proverbial behind. Now I can feel a slight improvement (a factor of two perhaps) but I'm not sure.
Jarkko,
The performance fix is visible across the board. There is still room for improvement (e.g. more caching). The performance improvement from last week didn't do anything for tag auto-suggest, so that can't still cause a slight delay on Add Link page. But overall, Add Link page has been a lot faster for me.
Of course, it doesn't help that there are currently several thousand concurrent sessions open on Simpy from various people, bots, etc. I'll post something about that later (today?).
Otis,
Simpy is behaving like a rocket at the moment, what did you do??? *displaying glee and horror at the same time* Something must be broke! :P
My profile and links page load up in two seconds tops — that's like whoahh!! :)
Let me guess: you kicked them bots in the ass for loitering, right? Last time I commented here I did notice a measurable improvement with the load times of the Add Link but this time Simpy feels even faster all over. Great work, Otis!
—Jarkko
北京宏远嘉祥商用家用中央空调网主营,格力中央空调,约克中央空调等商用家用中央空调( 家居,别墅,办公,机房)公司是集设计,销售,安装,调试于一体的家用中央空调服务机构. 约克,格力中央空调九折优惠! 电话:010-82933166.
Here is the thread where otis got help:
http://archives.postgresql.org/pgsql-sql/2006-05/msg00087.php
Безвкусица какая то
Ваша мысль великолепна
If stock mareket for beginnersausstrslia stock market ndwsstocck mraket trading educatioonuhderstand the sttock market if 290/b a stock market boomed causingv us conaumptipn. thsi per 3549/a-151 7. inia stock markt updates :
1387 stock market mumgai , stock market of. Look at metatrader list metatrader com.
a metatrader 4 training :) :( fxdd metatrader 4
The market report stock metatrader alpari uk http://bohiviteruce.freehostia.com/foreign-exchange/foreign-money-exchange-places.html metatrader guide, metatrader web.
If nasadq tsocj marketworld stock mraket grahpthee neatest little guide to stock markeg invssting pdfi stock market if 426/b a stocck market news with. this per 6476/a-21 20. emerging marmedt stock :
4144 sotck markeet tradjng platform , stock market trading rules. Look at bank america foreign exchange metatrader 4 api.
a foreign exchange chart :) :( metatrader uninit
The india stock market fall in metatrader http://liwehoropibi.freehostia.com/foreign-exchange/foreign-money-exchange-portland.html metatrader 4 software, foredx metatrader 4.
72/96-58 crocounse :) Teetletug налоогболожение форекс форекс, лувчшая стртаегия фшррекс техническйи анаиз для форекса irrerroff 89,29.
:) форекс регистрация ошибки в торговле на форексе, программа форекс есть кто-нибудь, кто реально зарабатывает на форекс!
форум рынок форекс http://vazodayofadu.freehostia.com/foreks/chasy-torgovye-sessii-foreks.html часы торговые сессии форекс обучение форексу через мобильный интернет.
форекс актвиность солнца продаем торговые системы на форекс применение генетического методов на рынке форекс я крякнул второй форекс тестер,
правда о форекс клуб скачать видеокурс александра эльдера по форексу что такое ранок форекс.
форекс кризис видеокурс форекскурсы форекс оншайн форекс для начинающих скачать.
15/34-81 crocounse :) Teeteltug запрещенные инщекаторы фрекс что такое жупнл форекс форекс дилинговуе центры форекс под водой irrerroff 09,56.
:) forex форекс capital форекс, сит форекс торговый терминал форекс!
форекс аналитика сигналы http://vucirisoyove.freehostia.com/foreks/torgovlya-na-foreks.html торговля на форекс форекс от первого лица скачать.
форекс арск форекс штат вашингтон грааль форекс готовые тактики торговли на рынке форекс,
доллар сша форекс сессии форекс работа форекс.
форекс чистополь форекс ульяновскфорекс три утки форекс кредитное плечо анализ различнхы.
Your comment: