Answers

• allan Posts: 61,668Questions: 1Answers: 10,096 Site admin

  October 2019 Answer ✓

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

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

  Allan
• Aries1104 Posts: 16Questions: 5Answers: 0

  October 2019

  slow load 1min o more .
  I am doing well the relationships between the tables.
• Aries1104 Posts: 16Questions: 5Answers: 0

  October 2019

  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 Posts: 61,668Questions: 1Answers: 10,096 Site admin

  October 2019

  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