I guess I can make it to the top 100 blogs…

…if the stats were just reset. Ha ha ha!

P.S. Please note that this is just for fun.

• GNOME Mobile & Embedded Initiative
  Tags: gnome linux mobile emb embedded
• Icron WiRanger
  Cable Free USB 2.0 Hub
  Tags: hardware usb hub wifi wireless
• TAXI 4
  Tags: taxi french movies films comedy
• DevPinoy
  "where Filipino developers synergize"
  Tags: pinoy programming
• Summer Time in the D.S.C.
  Featuring Maria Ozawa (aka Miyabi) [on YouTube]
  Tags: maria ozawa jav hiphop mtv musivideo
• Origami Starcraft
  via rjdavid@phpugph
  Tags: games origami art starcraft
• SimpleTest
  Unit Testing for PHP
  Tags: php testing programming

Last week, I tested one of the parts of my pet project. To be more precise, it was a stress test. The result wasn’t so bad. Through this test, I found out which parts can make the server bog down.

The application is simple. It’s a page that shows useful information to an inbound call center agent and a menu for call dispositions. It shows session data and statistics, queue information, call details and a list of call dispositions that they can choose. In short, it’s a helper screen with a touch of CRM.

The test was done on about 150 seats (I think). I think at production’s peak hours, it makes 26 queries per user every 5 seconds (8 of those are unchangeable because of authentication). So that should be about 780 querries per second. Those queries are called via AJAX.

Although that didn’t cause the server to crash, it reached the maximum number of users logged in at the database (using persistent connections).

To rectify it, I can increase that limit. But only losers do that. I’ll try some form of caching. I don’t know why I didn’t think of it before. My plan is to execute the 2 queries that are repeated every X seconds (call and queue data) and cache the results. That should reduce the load on the database. The session data can be event triggered, reducing it even further.

The cache will contain three directories at its root (S, C and Q)*. Then each directory should have the files containing the results in a file named with the key in the where clause. The format of the contents should be something similar to JSON (XML just takes too much work).

So when the AJAX request is sent, all it has to do then is get that file and print its contents (the client-side script parses that data already). At that point, the number of queries per second would’ve been reduced to a near-constant rate of 2 (excluding authentication).

Wow, parang ALGOCOM na rin.

*I think McDonald’s used it too. I think it was “service cleanliness and quality”.

Originally uploaded by Our Awesome Planet.

This is the sculpture/fountain/waterfall I was talking about. Habi House is at Serendra Piazza (not plaza, my bad).

So yesterday I attended PHPUGPH’s Meetup at The Mob (Market! Market!). Roy of Computer Professionals’ Union (CPU) and I won a camping chair from the raffle courtesy of TXTDomain. Congratulations to Clod (aka r00t) and his team for organizing the event.

After that, I checked out Pakshirts at Habi House. I usually don’t spend for shirts. The last time I bought one was when I was in high school. You probably won’t believe that the FILA, Converse and No Fear shirts that I wear are from my sixth grade.

When I found the shirt that I liked, the lady told me she didn’t have change. I was trying to kill time since it was still rush hour so I did the trouble of looking for change. I never bothered this much for one shirt. I discovered that Serendra is the kind of place where you’re meant to spend four to five digits. I had trouble looking for a place where I only had to spend less than a hundred Pesos to get change.

This is what you’d call a real plaza. There were lots of nice sculptures and fountains. There’s this one fountain that had a boulder mounted on a huge tripod and it had water falling down (so it’s actually a waterfall?). I’m too lazy to look for a picture, so it’s best that you check it out for yourself.

Habi House is an art gallery that features paintings by a certain artist every two weeks. Yes, I did a mini-interview on the Habi House lady. At least there’s a story for the trouble of getting one shirt and the last for this design. All for the sake of local art (…and fashion).

I really liked the one-liners but I’m the type of person that prefers cotton shirts. The shirt is made of a very elastic material. I’ll just give this as a gift.

As requested by Rick of Project Manila and for Sir Pat, here’s a picture of the shirt enjoying the camping chair that I got for free.

I was going to try out this ratified dot org thing but I guess somebody was playing with production stuff. Oh well, better try some other time.

Wow, I almost got into the top 100 blogs in the Philippine blogosphere (that’s what the site says). The screenshot below was from the other night.

Click to embiggen

Anyway, let’s not make this about me or my blog. I want to thank Elvin and Mano for doing my hair. They also do henna tattoos. I wanted to get a dreadlocked Tux as a sample but it was too late when I thought of it.

Mano is also a painter. He’s joining the 2007 GSIS Painting Competition. If you want to get your hair dreadlocked or braided, or a henna tattoo, you may reach Elvin at (910)567-7719 if you’re at Boracay or Mano when you’re at Manila at (920)417-8688. Mano also does face/body paintings.

• Yod’m 3D
  XGL/Beryl-like 3D spinning cube with virtual desktops for Windows (via Lifehacker)
  Tags: xgl beryl windows virtual desktops
• CodeGrrl.com - Taking the Grr out of coding
  run by Sasha and Vixx
  Tags: geeks coding girls
• Table Editor And Planner, Or: Teapot!
  a spread sheet program for UNIX
  Tags: spreadsheets curses excel
• Philippine Revolution Web Central
  Tags: philippines npa revolution rebels

Fedora 7 will be Generally Available on May 24 (not today, April 26). I was hoping to upgrade later with fingers and toes crossed that XGL/Compiz will work out of the box.

Originally uploaded by jp_loh.

In the middle of a busy day, I still manage to download, compile and install Asterisk 1.4.3. I’m amused by this ASCII art in the autoconf file.

Also, I’m curious why it looks for GTK2 (see first lines).