6
Mysql selecting random rows with large tables
No comments · Posted by KiloByteS in Uncategorized
Have you being asked to write an sql query that retrieves random rows? you you had then you will find it tricky! Database is designed locate specific information from the storage based on a given criteria, it peforms well when query specific into, but random rows is … a totally diffrent story…..
No tags
4
KIK KIK KOK KOK 94′ Theme Song: å二个为什么
1 Comment · Posted by KiloByteS in Uncategorized
This is one of my favorite theme song when I was in primary school dance class.
I can still remember we have quite some fun time, we traveled many places for peformance with sponcered trips to Penang and Kota Kinabalu!
Very unfortunate that I do not have any other photos except for this one. I also only have a VHS Video Cassette but again, I don’t have a player to play it!!
.
No tags
I just came back from a movie preview, this one is gonna be the best comedy movie of the year!
A Jack Neo Film, Just Follow Law(我在政府部门的日å) reveals most of our daily problem with people, society and the government.
Go go go! It’s gonna be a great movie for your weekend. The screen starts tomorrow!
No tags
Finally all the domain name issues are solved and successfully moved away from registerfly, now it is time to focus back to my personal productivity. Lately I had been spending too much time reading blogs and forum, too many had too many distraction to my life and wasn’t making any good progress on my projects.
I begin to analyse the situation based on the past few days and concluded that I need more self discipline. One of the root causes is that I did not get enough sleep daily, which directly affects my working efficiency. Second is that I did not specify a proper daily todo list and things goes out of sync, result in spending 20% of my working time to sort out tasks.
To maximize the working efficiently, I need to:
- Be and early riser, spent minimal time slumbering – Sleep early!
- Start a day knowing what to be done – Prepare a todo list!
- Keeping on schedule – Review performance and plan’s tomorrow task before going to bed!
I had been hanging around till late night for many years, and I had decided to stop to change some of my life style. I want to get up early, start my work as soon as I got my breakfast, extending my working hour from 8 to 12 hours a day!Â
Starting early doesn’t means being productive early, every morning I spent 45 minutes read my RSS feeds for daily news, and I had been suggested to swap the rss task to the end of the day while utilizing the time to recall what has to be done by that single day! Good to have a practice that take advantage on morning freshness!
While before going to bed, I will review stuff that went wrong today, prepare a new todo list for tomorrow. Be sure I ask my self ‘Why It Happened’ on every single problem, and of course solve it, try not to repeat the same mistakes!
Hopefully these three techniques will increase my productivity! Currently I have 3 active projects to work with, and about 7 lower priority projects are waiting for me. Initial schedule shows that I can only finish all of it by November 2008, let’s see is it possible to cut the timeline down to half!
Good night!
No tags
Despite the fight within Registerfly, I finally to moved out from them, transferring all my domain name out to another registrar. $%@ I still have $40 bucks stuck in that account!
During the transfer only I realise that the cost of renewing a .info are the same as purchasing a .com :p. Well why not get my self a kaybin.com? It looks nice!
I wonder what kind of website I should be putting over there. May be my profile?, photo gallery?
No tags
2
Registerfly faces loosing ICANN accreditation…
2 Comments · Posted by KiloByteS in Uncategorized
Registerfly faces losing ICANN accreditation
Ars Technica, MA - 27 Feb 2007
Domain registrar and SSL certificate issuer Registerfly has been given notice by ICANN for violation of numerous policies and must remedy the situation by …
Ok, It seems that my domain (thekilobytes.net) are going to be in some trouble as they are going to be expired soon…
No tags
It has been quite a while since my last post, I have been visiting around friend and relative house during the Chinese New Year, sadly I didn’t make any fortune of money during the period of time.
I got shocked when i see there are tons of spam messages on post comment and my shoutbox! I’m gonna build some custom filter to ensure spam post will go away forever! For the mean time, I’ll pull down the shoutbox and do some tweaks to the theme. How do you like this one?
No tags
I just came back from MBPJ to pay my SAMAN KOMPOUN, it was so crowded, everyone is renewing their Cukai Cukai!
I don’t to go MBPJ to settle stuff! Don’t you agree that it is  stupid that they cramp all the renewal process to January of every year? why can’t they do it quarterly.
Ok. Usually my headache begins when i arrived there…
PARKING is the first thing i do, then…
QUEUE …. for form request/paper stuff, … then
QUEUE …. again for payment, … and finally
QUEUE!!! again …. for item retrival..
Can we just have a KIOSK that swipes MyKad, Cash Deposite, Retrieve Reciept, and done?
Here is somehow Interesting, today I saw a Drive Thru Counter between the MBPJ Office and Civic Hall. It settles all the bill payment stuff, (Englarge the photo below if wanna see what transaction they deals with).
![]()
![]()
![]()
Not bad tough, You don’t have to spent hours to find parking and queue! Each transaction will takes about 3-5 minutes. Here is my advise. If you see there are 12 cars infront of you, don’t go in :p
There are minor updates, Dog licensing (and other) no longer served at the tall MBPJ building, It is all being done at the HQ Next to Civic halls.
No tags
Hurry grab some free seat! It will only cost you RM 40-65 for domestic tax!
I subscribed to Air Asia mailing list and I recivied the promotion notice one day before the launching day, so I manage to grab a few free flight for this year, traveling everywhere! Its pretty easy.
…wait a minute, easy???
Well the fact is, due to the promotion, Air Asia website are often congested, and barely able to make any bookings! it is fustrating! But there is a SOLUTION! a way of booking that is MUCH EASIER, Try Air Asia mobile website at http://mobile.airasia.com, It is least congested, you can access it nearly everywhere mobile, even on your computer.
Good luck on the bookings! Don’t screw up with your Name and Identity number!
No tags
Just like to share out a list of malaysia postal code area directory (poskod malaysia).
| Kawasan / Area | Poskod / Postcode | |
|---|---|---|
| Kuala Lumpur & Petaling Jaya | 46000-46999 | Petaling Jaya |
| 47200 | Subang | |
| 47300-47499 | Petaling Jaya | |
| 47800-47810 | Petaling Jaya | |
| 50000-50999 | Kuala Lumpur | |
| 60000 | Kuala Lumpur | |
| 68000 | Ampang | |
| 68100 | Batu Caves | |
| Shah Alam | 40000-40999 | Shah Alam |
| 47100 | Puchong | |
| 47500-47600 | Subang Jaya / USJ | |
| Klang | 41000-41999 | Klang |
| 42100-42199 | Klang | |
| 42000 | Pelabuhan Klang | |
| Kajang | 43000-43010 | Kajang |
| 43030 | Bukit Dukong | |
| 43200 | Batu 9, cheras | |
| 43400 | Seri Kembangan | |
| 43600 | UPM Serdang | |
| 43600 | UKM Bangi | |
| 43650 | Banda Baru Bangi | |
| 62000 | Putrajaya | |
| 63000 | Cyberjaya | |
| Pulau Pinang | 10000-10999 | Pulau Pinang |
| 11200 | Tangung Bungah | |
| 11400 | Penang | |
| 11600 | Pulau Pinang | |
| 11700 | Gelugor | |
| 11900 | Bayan Lepas | |
| Butterworth | 12000-12999 | Butterworth |
| Bukit Mertajam | 14000-14009 | Bukit Mertajam |
| Johor Bahru | 80000-80999 | Johor Bahru |
| 81200 | Johor Bahru | |
| Kluang | 86000 | Kluang |
| Batu Pahat | 83000-83050 | Batu Pahat |
| Muar | 84000-84009 | Muar |
| Pasir Gudang | 81700-81709 | Pasir Gudang |
| Kuantan | 25000-25999 | Kuantan |
| Melaka | 75000-75450 | Melaka |
| Seremban | 70000-70999 | Seremban |
| Nilai | 71800-71850 | Nilai |
| Ipoh | 30000-30999 | Ipoh |
| 31350 | Ipoh | |
| 31400 | Ipoh | |
| Taiping | 34000-34009 | Taiping |
| Teluk Intan | 36000 | Teluk Intan |
| Alor Setar | 05000-05999 | Alor Setar |
| 06250 | Alor Setar | |
| 06550 | Alor Setar | |
| 06560 | Alor Setar | |
| 06570 | Alor Setar | |
| Kulim | 09000 | Kulim |
| 09600 | Lunas | |
| Sg. Petani | 08000 | Sg. Petani |
| Kangar | 01000 | Kangar |
If you find it useful or you have any idea to futher make use of it, drop me a comment.
No tags
