缓存查询超过了10240 KB的内存限制

你好，我正在尝试run queries为我的searching

但是我得到了这个结果

Error Number: IMSSP/-59

Memory limit of 10240kb exceeded for缓冲查询

这是我的查询

SELECT * From transaksi a 
left join Outlet b on a.Outlet = b.OutletCode
left join area c on b.areacode = c.areacode where b.BrandCode like  '%AR-1%'
and b.areacode like '%%' and b.OutletCode like '%%' and tanggal 
between '2016-03-01' and '2016-07-31'

从上面的查询我得到16046 rows。

—A Test—

当我尝试做一些只显示10 rows的其他搜索时，该错误未显示。

SELECT * From transaksi a 
left join Outlet b on a.Outlet = b.OutletCode
left join area c on b.areacode = c.areacode where b.BrandCode like  '%AR-1%'
and b.areacode like '%%' and b.OutletCode like '%K-SRLM%' and tanggal 
between '2016-05-01' and '2016-05-10'

这里没有使用range显示411 rows

SELECT * From transaksi a 
left join Outlet b on a.Outlet = b.OutletCode
left join area c on b.areacode = c.areacode where b.BrandCode like  '%AR-1%'
and b.areacode like '%%' and b.OutletCode like '%K-SRLM%'

这是我的全文。

function show_it()
    {
        extract(populateform());
        if($date_search == "")
        {
            unset($date_search);
        }
        if(isset($date_search)){
        $explode = explode('-',$date_search);
        $start_date = inggris_date($explode[0]);
        $end_date = inggris_date($explode[1]);
        $result = $this->modelmodel->showdata("SELECT * From transaksi a 
                                                left join Outlet b on a.Outlet = b.OutletCode
                                                left join area c on b.areacode = c.areacode where b.BrandCode like  '%$tipenya%'
                                                and b.areacode like '%$area%' and b.OutletCode like '%$outlet%' and tanggal 
                                                between '$start_date' and '$end_date'
                                                ");
        }else{
        $result = $this->modelmodel->showdata("SELECT * From transaksi a 
                                                left join Outlet b on a.Outlet = b.OutletCode
                                                left join area c on b.areacode = c.areacode where b.BrandCode like '%$tipenya%'
                                                and b.areacode like '%$area%' and b.OutletCode like '%$outlet%' 
                                                ");
        }   
    }