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! -- AngelHanielCantuJauregui angel.cantu@moneybox.business <mailto: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 <tel:(818) 421 9924> | (899) 871 1722 <https://wa.me/528998711722> angel.cantu@moneybox.business <mailto:angel.cantu@moneybox.business> https://www.moneybox.business 20 de noviembre #300, CP 88780 Reynosa, Tamps, Mexico facebook <https://business.facebook.com/moneyboxco/> twitter <https://twitter.com/moneyboxlatam/> linkedin <https://www.linkedin.com/company/27011448/> instagram <https://www.instagram.com/moneyboxlatam/> <https://www.moneybox.business>
