July 2008 Archives

I have a web-based program with MySQL database. I need to do a full text search on three fields.
How can I do it?
Use 'LIKE' is very slow, when I need combination of different situation.

So I find FULLTEXT index of MySQL.

*A full-text index in MySQL is an index of type FULLTEXT.
*Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
*A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX.
*For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index.

I add a FULLTEXT index into the current table with three fields.
The search query is simply and results is fast.
MATCH (col1,col2,...) AGAINST (expr [search_modifier])
If no results coming up, it maybe no results or the results is over 50% of the whole table.

I am still using Joomla! 1.5.3 on some sites.
What about the Joomla! 1.5.5 and previous 1.5.4?

Let us just focus on the new release.

The Joomla! community is pleased to announce the immediate availability of Joomla! 1.5.5 [Mamni]. This is a quick turnaround release to address the Duplicate Title error from 1.5.4 . This release also contains important SEF URL improvements and fixes for com_content in addition to a number of bug fixes and improvements. It has been nearly three weeks since Joomla! 1.5.4 was released on July 8, 2008. The Development Working Group 's goal is to continue to provide regular, frequent updates to the Joomla! community.

Here is the official announcement.

For me, I don't want to upgrade it manually. I am waiting for the Dreamhost one-click installation.

I would like to introduce a site, CXTEC, which provide the very basic of the Internet, network cable. We all know that the internet has unlimited sites hosted on the web servers which are connected by the network cables.

It is so popular that a lot of people will omit it. Actually when I build my home network, I use a brand name cable. Not from CXTEC, I don't know CXTEC network cables at that time. :(

If you want to have a network and thinking about the network cables, I suggested you to read the following quoted.

The cable connection can be highly customized to any given network and can range from a simple Ethernet cable all the way up to copper, fiber optic, and specialty cables. Although there are others, the main difference in these different types of cables is connection speed (Ethernet being the slowest and fiber optic or specialty being the fastest).

Because each network is so unique, it is important to evaluate your own needs before choosing which type of cable to use.

I have an example of bad cables. The network connection is not stable. Some time OK, some time very slow or loss the connection. Do you know how to solve it? Just change the cable between the modem and router.

Fido, one of the Canadian cell phone carriers, gave a 500 error on its official site.

It is hacked? or under attack?

Every time I upgrade my Ubuntu desktop, a new kernels comes in. Then I have a new kernel and old one will never be used.

Time by time. I have 6 or more kernels in the booting list and I don't want to see. How can I remove them.

I got the way to do this cleaning job.
1) Check my current kernel I use by command as below:

uname -r

The response tells the current version number

2.6.24-19-generic

2) Open the Synaptic package manager from the System->Administration menu.

I would like to introduce this network for every Canadian adult.
I joined this network and have my blood information on its database.

The first step to do is to go to One Match site. Filling the online form and wait them contact you.
Basicly you will get an phone call to confirm you really want to join it and make sure you know what you do.

Then you will receive a mail with a test swab pack including return envelope.
The test kit has instruction and it is easy for you to collect test sample yourself.
I have an photo of it.

Just use the swab to touch the inner cheek to get sample by four times. And mail it out.

The network will let lab to doing the test and try to match it with others'.

If match, you can save a life.

Do not fear the process to retrive the stem cell. It is a hi-tech age. Stem cells can be obtained from the circulating blood.

My 4 and half years old daughter, Gloria, is pointing her Mii.

Just come back from San Francisco last Saturday. We went to T&T and Costco for grocery.
Later afternoon, we stopped in the EB Games, a game store.

We found Wii there and it is $269.00 with Wii Sports. After a short discussing with Vivian and We decided to buy it.

Grace and Gloria are so exciting. When we headed into home with the Wii box, they can not wait any more.
I unpacked the box, connect the cables and setup the console. They phoned their friends to announce this great news.

I do like the Tennis. I played about 1 hour yesterday. I think it works on fitness job.

See some photos in the next post.