Hi.

I have problems to make query to a table from the db, is delaying so much (too slow), I don't know whats I need to do, I do some test to my code but is not the problem, is the table.

When I make a select to the table marked with red, the response delay 6 or 8 seconds, but, if I do a query to another table the response delay 1 second (fast). Only the table marked with red is delaying.

I do this specific query:

select * from FACTURACION where ID_USER='ID_HASH' order by SERVER_DATE limit 1,12;

I only query the first 12 results order by date, and in the code I make the pagination using "?page=NUMBER"

Regards!

Angel Haniel Cantu Jauregui

angel.cantu@moneybox.business

Gerencia | Servicios de Innovacion para Empresas SA de CV

Proveemos soluciones para facilitar la administración de tu negocio y
garantizar tus próximas vacaciones en compañia de tu familia sin preocupaciones

(818) 421 9924 | (899) 871 1722

angel.cantu@moneybox.business

https://www.moneybox.business

20 de noviembre #300, CP 88780
Reynosa, Tamps, Mexico