January 2012
11 posts
6 tags
Installing Sphinx Search on Basic 64-bit Amazon...
This is a simple step by step in installing Sphinx Search on Basic 64-bit Amazon Linux AMI. This is applicable to 32-bit too. This installation is very bare, starting from zero installation at all.
The conditions I wanted to meet:
Using the very latest Sphinx Search documents. And when I say latest, I mean it. I am using Sphinx Search trunk, because I need the RealTime Indexing (RT Index) and...
Using Sphinx as denormalized table: Need your...
Hey guys, I need your point of view on this. So I have this query, which can take up to 17 (Seventeen!) tables into one query. I have been using Sphinx a lot for searches, and luckily, since Sphinx 1.10-beta, we have this attribute called sql_attr_string. What this attribute does is store the value for retrieval at Sphinx. So this is what I get (below is a sphinx index):
mysql> select...
Fighting Content Piracy →
aulia-m:
From Jakarta Globe:
Business models should be based on customer demand and an understanding of what is technically feasible - not a desire to maintain existing models or cash flows. In other words, you need to adapt the map to the terrain - you cannot change the terrain to suit the map.
Object runs faster than array!
Amazing new finding again. Now take a look at this:
foreach ($query->result_array() as $page):
$links .= '<a href="'.site_url($page['uri']).'">';
$links .= ucwords($page['title']).'</a><br />';
endforeach;
compared to this:
foreach ($query->result() as $page):
$links .= '<a href="'.site_url($page->uri).'">';
$links .=...
Foreach Loop Optimization
This is crazy! I’ve just found out that:
$pages = $query->result_array();
foreach ($pages as $page):
is a lot faster than:
foreach ($query->result_array() as $page):
Crazy! It happens that $query->result_array() is called multiple times if you put it inside the foreach(). I need to learn more…