lento

lento

Aries1104Aries1104 Posts: 4Questions: 1Answers: 0

funciona pero tarda mucho alguna sugerencia

Answers

  • allanallan Posts: 50,737Questions: 1Answers: 7,581 Site admin

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

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

    Allan

  • Aries1104Aries1104 Posts: 4Questions: 1Answers: 0

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

  • Aries1104Aries1104 Posts: 4Questions: 1Answers: 0

    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":[]}]}

  • allanallan Posts: 50,737Questions: 1Answers: 7,581 Site admin

    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

Sign In or Register to comment.