In my application the following errors are shown, however one,
however another one, when I search a great amount of data.
When the amount is small this does not occur:
Fatal error: Maximum execution time of 30 seconds
exceeded in /www/wlinux668/public_html/gestao/tbs/tbs_class.php on line 1193
our
Fatal error: Allowed memory size of 16777216 bytes exhausted
(tried to allocate 593 bytes) in /www/wlinux668/public_html/gestao/tbs/tbs_class.php on line 1193
When I carry through the direct research in mysql,
I obtain a waited result fast, as it can below be seen in exempo:
********
Mostrando registros 41520 - 41540 (41,541 total,
Consulta levou 1.3206 segundos)consulta SQL:
******
This is my SELECT in such a way in the application,
how much in the direct consultation:
SELECT est_entrada.id AS id, est_produto.descricao AS descricao,
est_entrada.quantidade AS qtd,
est_entrada.vr_custounitario AS vr_unitario,
est_estoque.descricao AS estoque,
est_entrada.referencia AS referencia,
est_fornecedor.descricao AS fornecedor, est_entrada.data AS data
FROM est_entrada
INNER JOIN est_estoque ON est_entrada.id_estoque = est_estoque.id
INNER JOIN est_produto ON est_entrada.id_produto = est_produto.id
LEFT JOIN est_saida ON est_saida.id_entrada = est_entrada.id
INNER JOIN est_grupo ON est_subgrupo.id_grupo = est_grupo.id
INNER JOIN est_subgrupo ON est_entrada.id_subgrupo = est_subgrupo.id
INNER JOIN est_fornecedor ON est_entrada.id_fornecedor = est_fornecedor.id
WHERE est_entrada.data >= '1990-01-01'
AND est_entrada.data <= '2006-11-04'
AND est_produto.descricao LIKE '%%'
GROUP BY est_entrada.id
ORDER BY est_estoque.descricao, est_entrada.data
LIMIT 41520 , 30
*******
This is the part of my code that could be intervening, also the functions:
......
PHP
........
$TBS->MergeBlock('blk_est',$cnx_id,$sql_est);
$tt_rec = $TBS->MergeBlock('blk',$cnx_id,$sql);
if (isset($tot_1)) $tot_est_all[] = $tot_1;
if (isset($tot_2)) $tot_data_all[] = $tot_2;
if (isset($tot_1_vr)) $tot_est_all_vr[] = $tot_1_vr;
if (isset($tot_2_vr)) $tot_data_all_vr[] = $tot_2_vr;
mysql_close($cnx_id) ;
$TBS->Show(TBS_OUTPUT);
function f_total($Name,&$CurrRec,$RecNum) {
global $save_est, $tot_1,$tot_2, $tot_1_vr,$tot_2_vr,$tot_est_all,$tot_data_all,$tot_est_all_vr,$tot_data_all_vr,$save_data,$id_lista;
if (!isset($save_est)) {
$save_est = '';
$tot_est_all = array();
};
if (!isset($save_data)) {
$save_data = '';
$tot_data_all = array();
};
if (($save_est!=$CurrRec['estoque']) ){
if (isset($tot_1)) {
$tot_est_all[] = $tot_1;
$tot_data_all[] = $tot_2;
$tot_est_all_vr[] = $tot_1_vr;
$tot_data_all_vr[] = $tot_2_vr;
};
$tt_item = 0;
$tot_1 = 0;
$tot_2 = 0;
$tot_1_vr = 0;
$tot_2_vr = 0;
$save_est= $CurrRec['estoque'];
$save_data= $CurrRec['data'];
};
if (($save_data!=$CurrRec['data']) ){
if (isset($tot_2)){
$tot_data_all[] = $tot_2;
$tot_data_all_vr[] = $tot_2_vr;
};
$tot_2 = 0;
$tot_2_vr = 0;
$save_data= $CurrRec['data'];
};
// Calculate totals
if ($id_lista=='3'){
if ($CurrRec['qtd_s']==0) {
$CurrRec['qtd']=$CurrRec['qtd_e'];
}else {
$CurrRec['qtd']=($CurrRec['qtd_e']-$CurrRec['qtd_s']);
};
};
$tot_1 += $CurrRec['qtd'];
$tot_2 += $CurrRec['qtd'];
$tot_1_vr += ($CurrRec['qtd']*$CurrRec['vr_unitario']);
$tot_2_vr += ($CurrRec['qtd']*$CurrRec['vr_unitario']);
$CurrRec['tt_item']=($CurrRec['qtd']*$CurrRec['vr_unitario']);
$CurrRec['total'] = 1;
};
function f_seq_est($FieldName,&$CurrVal) {
global $tot_id, $tot_est_all;
if (!isset($tot_id)) $tot_id = 0;
$CurrVal = $tot_est_all[$tot_id];
$tot_id++;
};
function f_seq_data($FieldName,&$CurrVal) {
global $tot_id2, $tot_data_all;
if (!isset($tot_id2)) $tot_id2 = 0;
$CurrVal = $tot_data_all[$tot_id2];
$tot_id2++;
};
function f_seq_est_vr($FieldName,&$CurrVal) {
global $tot_id3, $tot_est_all_vr;
if (!isset($tot_id3)) $tot_id3 = 0;
$CurrVal = $tot_est_all_vr[$tot_id3];
$tot_id3++;
};
function f_seq_data_vr($FieldName,&$CurrVal) {
global $tot_id4, $tot_data_all_vr;
if (!isset($tot_id4)) $tot_id4 = 0;
$CurrVal = $tot_data_all_vr[$tot_id4];
$tot_id4++;
};
............
HTML
.............
<tr valign="top">
<td>[blk.data;frm='dd/mm']</td>
<td>
<a href="entrada_ficha.php?id_entrada=[blk.id]&id_lista=[var.id_lista]&per_ini=[var.per_ini]&per_fim=[var.per_fim]&id_estoque=[var.id_estoque]&nome_campo=[var.nome_campo]&desc_produto=[var.desc_produto]">
[blk.id;block=tr;aggregate=qtd:acc,tt_item:acc;ondata=f_soma]</a></td>
<td>[blk.descricao] [blk.referencia]</td>
<td>[blk.fornecedor]</td>
<td align="center" class="line2">[blk.qtd]</td>
<td align="right">[blk.vr_unitario;frm='000.000,00']</td>
<td align="right" class="line2">[blk.tt_item;frm='000.000,00']</td>
</tr>
<tr class="line2">[onshow;when [var.id_agrup]==1;block=tr]
<td colspan="4"><b><img src="[var.dir_icone]seta_verde.gif" />
Total do Dia [blk.data;frm='dd/mm/yyyy';block=tr;footergrp=data]</b></td>
<td align="center"><b>[var.tot_data_all;onformat=f_seq_data]</b></td>
<td align="center" > </td>
<td align="right"><b>[var.tot_data_all_vr;frm='000.000,00';onformat=f_seq_data_vr]</b></td>
</tr>
<tr class="line2">
<td colspan="4"><b><img src="[var.dir_icone]seta_laranja.gif" />
Total do Estoque [blk.estoque;block=tr;footergrp=estoque;ondata=f_total]
</b></td>
<td align="center"><b>[var.tot_est_all;onformat=f_seq_est]</b></td>
<td align="center"> </td>
<td align="right"><b>[var.tot_est_all_vr;frm='000.000,00';onformat=f_seq_est_vr]</b></td>
</tr>
<tr class="line1">
<td colspan="4"><b>>> TOTAL DA PESQUISA</b></td>
<td align="center"><b>[blk.qtd:acc]</b></td>
<td align="center"> </td>
<td align="right"><b>[blk.tt_item:acc;frm='000.000,00']</b></td>
</tr>
*******************
I am showing only the part of the code that I imagine either enough
so that you it can guide me on what it is occurring.
*** Note that, for a small amount of data, let us say 700 lines in the result,
I obtain the waited result, however, when the amount is bigger, the cited messages are shown.