Zend Framework table Relationships

Question

I have a table with over 4 million rows, I want to split this table in more tables, i.e one table with 50k rows. I also need to perform a search on these tables, whats the best way to do it? with JOIN, or? do you have some better ideas?

Best Regards,

QUERY

            $do = $this->select()
              ->where('branche LIKE ?',''.mysql_escape_string($branche).'%')
              ->order('premium DESC');  

Zend_Paginator

        $d = $firmen->doSearch($finalType,$theKeyword,$thePLZ,$theBranche,false,false,false,$theOrder);

    $paginator = new Zend_Paginator(

    new Zend_Paginator_Adapter_DbSelect($d)
    );      

    if ($d !== false) {
        //$paginator = Zend_Paginator::factory($d);
        $paginator->setItemCountPerPage(5)
                  ->setPageRange(10)
                  ->setCurrentPageNumber($pag);

        $this->view->data = $paginator;

Answer 1

Why do you want to split them? Performance issues?