lento

Aries1104

funciona pero tarda mucho alguna sugerencia

allan

No estoy seguro de cuál es tu pregunta en realidad.

(English: I'm not sure what your question actually is?).

Allan

Aries1104

slow load 1min o more .
I am doing well the relationships between the tables.

Aries1104

when the table has 4000 records it does not load
Warning: PDOStatement::execute(): MySQL server has gone away in C:\AppServ\www\FullMonitoring\Captura\php\lib\Database\Driver\MysqlQuery.php on line 105

Warning: PDOStatement::execute(): Error reading result set's header in C:\AppServ\www\FullMonitoring\Captura\php\lib\Database\Driver\MysqlQuery.php on line 105
{"fieldErrors":[],"error":"An SQL error occurred: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","data":[],"ipOpts":[],"cancelled":[],"debug":[{"query":"SELECT IDCliente as 'IDCliente', fullmonitoring2.pdate as 'fullmonitoring2.pdate', fullmonitoring2.hora as 'fullmonitoring2.hora', fullmonitoring2.panelcode as 'fullmonitoring2.panelcode', fullmonitoring2.campaign as 'fullmonitoring2.campaign', fullmonitoring2.photocode as 'fullmonitoring2.photocode', fullmonitoring2.cat as 'fullmonitoring2.cat' FROM fullmonitoring2 WHERE fullmonitoring2.status = :where_0 ","bindings":[{"name":":where_0","value":"1","type":null}]},{"query":"SELECT DISTINCT fullmonitoring2.campaign as 'dteditor_pkey', sector.descrip as 'descrip' FROM fullmonitoring2 as fullmonitoring2 JOIN campana ON fullmonitoring2.campaign = campana.descrip JOIN sector ON sector.code = campana.sector ","bindings":[]},{"query":"SELECT DISTINCT descrip as 'descrip', descrip as 'descrip' FROM sector ","bindings":[]},{"query":"SELECT DISTINCT fullmonitoring2.campaign as 'dteditor_pkey', subsector.descrip as 'descrip' FROM fullmonitoring2 as fullmonitoring2 JOIN campana ON fullmonitoring2.campaign = campana.descrip JOIN subsector ON subsector.code = campana.subsector ","bindings":[]},{"query":"SELECT DISTINCT descrip as 'descrip', descrip as 'descrip' FROM subsector ","bindings":[]},{"query":"SELECT DISTINCT fullmonitoring2.campaign as 'dteditor_pkey', marca.descrip as 'descrip' FROM fullmonitoring2 as fullmonitoring2 JOIN campana ON fullmonitoring2.campaign = campana.descrip JOIN marca ON marca.code = campana.marca ","bindings":[]},{"query":"SELECT DISTINCT descrip as 'descrip', descrip as 'descrip' FROM marca ","bindings":[]},{"query":"SELECT DISTINCT fullmonitoring2.campaign as 'dteditor_pkey', producto.descrip as 'descrip' FROM fullmonitoring2 as fullmonitoring2 JOIN campana ON fullmonitoring2.campaign = campana.descrip JOIN producto ON producto.code = campana.producto ","bindings":[]},{"query":"SELECT DISTINCT descrip as 'descrip', descrip as 'descrip' FROM producto ","bindings":[]},{"query":"SELECT DISTINCT fullmonitoring2.campaign as 'dteditor_pkey', tipo.descrip as 'descrip' FROM fullmonitoring2 as fullmonitoring2 JOIN campana ON fullmonitoring2.campaign = campana.descrip JOIN tipo ON tipo.code = campana.tipo ","bindings":[]},{"query":"SELECT DISTINCT descrip as 'descrip', descrip as 'descrip' FROM tipo ","bindings":[]},{"query":"SELECT DISTINCT fullmonitoring2.panelcode as 'dteditor_pkey', catorcena.contractor as 'contractor', catorcena.county as 'county', catorcena.address as 'address', catorcena.medio as 'medio', catorcena.medidas as 'medidas', catorcena.Formato as 'Formato', catorcena.size as 'size', catorcena.precio as 'precio', catorcena.longitud as 'longitud', catorcena.latitud as 'latitud', catorcena.RespPhoto as 'RespPhoto' FROM fullmonitoring2 as fullmonitoring2 JOIN catorcena ON catorcena.panelcode = fullmonitoring2.panelcode ","bindings":[]}]}

allan

4000 isn't very make to get an error like that. However, perhaps it would be worth using server-side processing to speed things up.

Allan