[cobaku]

this line makes very heavy load on mysql
could anyone give me how to alter the table so
mysql may drop the load
is it something like this ?

PHP Code:

alter table tablename add index (cell1,cell2); 


if this is not solved this mod is completely useless for most of the people

PHP Code:

 $q = "
                        SELECT
                            st.*, sd.founded
                        FROM
                            ".$searchterms_data." sd
                        LEFT JOIN
                            ".$searchterms." st
                            ON
                            sd.stid = st.stid
                        WHERE
                            
                            sd.page_type = '".$type_id['type']."'
                            AND
                            sd.page_id = ".$type_id['id']."
                        ORDER BY
                            sd.founded DESC";