Monthly Archives: September 2021

Orchid shopping street resting

Before Covid-19’s, orchid road is always crowed, even more in the weekend. Singaporean likes go outside shopping, eating. But now, shopping street is in rest.

Orchid shopping street during Covid-19’s

Ghim moh carrot cake

This morning 30-min cycling to Ghim Moh to buy my favorite carrot cake. My son said carrot cake in Redhill market not good.

As normal, long queue. The family cooker is busy to cooking white and black carrot cake. The young boss is preparing eggs and ask each customer preorder. Each time asks 4-5 persons and still remember what we order. Pretty memory.

Cycling outside city, along ulu pandas river

3 years ago, in the evening, I like to walking along ulu pandan river, near Ghim moh and holland village. Since railway green way open and Covid-19, has never come.

This weekend, cycling along ulu pandas river. Staring from commonwealth ave entry near grim moh, and ending commonwealth near ending hiring east.

There are many upgrading and changes. Many years ago, only one walking road along the river. Now there is another walking road in another side. Great jobs of Singapore government.

I still remember fishing in the river with friends when my child is kindergarten and primary school.

Ulu pandan river is great cycling, sport, and rest for neighborhood. You can cycling from west along the river then connect to city along the railway green road.

Huber’s favourite chicken jerky

My family Huber, loves chicken. Previously, we cook boiled chicken to him. For his health, it is better to feed dried chicken, like dog dry food.

Huber

From a few weeks ago, after boiling chicken meat, I slice chicken meat into thin and dry them using flat iron pan.

Dried chicken meat food for dog

After 20 minutes, dry off water in chicken meat and it is ready to cut to granule. One chicken is just enough for 1-week feed.

SQL optimization – long tail affecting performance

It often happens that you need join multiple tables (more than two) into one and do some computation. the you will find many instances are long tails. All other instances complete, long tail instances still running. For example, normal instances may 1 hour completed but long tail may more than 24 hours even worse it halt there.

For example, write a sql to do text information retrieval, ie, a query document table to match a target document database, with constrain of only selected query and target document pair are needed to calculate score.

Let saying 3 tables are query, target, candidate. Normally, you can join 3 at one time, like

Select other-score ……
from query q
Join target t
On q.word=t.word
Join candidate c
On q.id=c.query_id
And t.id=c.target_id
……

In big data, query, target and candidate maybe millions, which is normal. But word distribution along document is very skew, following 80-20 rule or Pareto principle. It will cause above join operation having serious long tail issue.

In my practice, some normal instances completed about a few hours, but long tails running more than 1 day and still halting there without any progress.

After analyzing, change 3 join at one time into first join query and candidate, and their result join target. Only this logic change, the task complete at 1 hour without any long tail, data skew. Comparing with before , the task cannot successfully completed even after running 24 hours.

It is amazing performance improvement.

Electric vs non-electric pressure cooker

In my kitchen, I have a set of pressure cooker, a 4.5L and 2L. It is non-electric.

Electric pressure cooker has more functions you can select on menu. But frankly, most of time, we use default setting. But I like non-electric pressure cooker. I do not want to worry the fault of sensor. (I have bad experiences of buying rice cooker. Just after 2 weeks, sensor is fault and water leaks into panel.)

When I wandered the Shaw center shopping mall many years ago, I found pressure cooker promotion. It is Fissler brand. About 700 Sgd for 2 set package. It is heavy, thick steel. Looks good. This was first time I bought so expensive cookware. But it is worthy.

It is safe and easy to use. I used them often, cooking Chinese braised beef with soy sauce, cooking soup, cooking Chinese congee. I used more than 5 years, it still work and there is no any fault like electric cooker.

Ghim Moh market – Carrot cake

Delicious carrot cake

When I live in Holland village, every weekend or holiday morning, I go to the carrot cake shop to buy breakfast for my family.

The shop only sells carrot cake, and its carrot cake is traditionally handmade. I have not find any shop cooking professionally like it. Every morning, it is a long queue about 20. Most time I need wait for 30mins.

The carrot cake cooks with carrot cake, salted dry carrot , eggs. You can watch how the boss, mother and father, cook and their son serves the customers.

You can buy white or black carrot cake. The difference is the latter is cooked with sweet sauces. If you like chilli, the white carrot cake can mix with chilli. My family love white one with chilli.

It is cheap delicious food, you can buy cheapest one for 2.5 SG dollar. But I always buy 3 dollar enough for single.

If you travel to Singapore, it is highly recommended food.

Hen, chick, and hen in neighboring park,楼下的母鸡小鸡和公鸡

母鸡和小鸡, hen and chicks. How many chicks you find?

In the neighborhood park outside the Hdb house building, there is a hen with her chicks, about 4. Every morning when I and my Huber walking along the small park road, they are wandering the flowers and grasses, searching food. There is also a red cock, he is crowing.

When Huber saw them first time, he wanted to play with them. But they are fighting. My Huber fled.

在住宅楼下的花丛和草地里,1只母鸡带着4、5只小鸡,每天在觅食。一只大红公鸡,大早晨的不断打鸣。

早晨带着我们的小黑狗huber 在楼下遛弯儿,常常看到他们。第一次见到母鸡和小鸡的时候,hubber想上去打个招呼,结果招致母鸡恶狠狠的上来,要啄他,吓得小黑狗落荒而逃。以后在见到他们,就躲远了。

« Older Entries Recent Entries »