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
|
|
|
|
|
|
|
|
|
|
|
 |
|