[SOLVED] Searching Big Database

[ballouta]

Hello,

 

I am wondering if there is other techniques for searching a big text database rather than the the turorial here:

http://www.phpfreaks.com/tutorial/simple-sql-search

 

Thank you

[dreamwest]

How big are the fields??

 

If you have say a million rows, your only going to select 20 or so at a time....20 isnt so much

 

I have 2 ables at the moment with over 800,000 rows and they query fast

[ballouta]

oh, No

it is around 10.000 rows only

and the fields i am searching in are: title (varchar) and content (longtext)

 

Thank you

[dreamwest]

Heres what im using it queries my 800,000 row table in less than 0.003 seconds

 

$search=$_REQUEST['search_id'];
$search = mysql_real_escape_string($search);

$result = mysql_query("SELECT distinct * from video  where (title like '%{$search}%') group by title limit 40 );

   while  ( $tmp = mysql_fetch_assoc( $result ) )
    {
        echo $tmp['whatever']."<br>";
    }

[ballouta]

Thank You