what about better faster whit two datatables?

what about better faster whit two datatables?

alfredone1alfredone1 Posts: 2Questions: 1Answers: 0

hi my name is alfredo i'm new in dataTables usage and i have a question. i'm working right now in a php page server processing with two datatables..how i can make faster loading in particular loading of filtersearching? when the datatables are load ..the problem is about filtering on a serversideprocessing whit a lot of table in sql and using more than one view from database so very slow .For me is very important resolve this situation because it's part of my duty..please help me.have a nice day

Answers

  • allanallan Posts: 63,761Questions: 1Answers: 10,510 Site admin

    If you are using server-side processing then a slow response will be due to one of:

    1. Slow SQL query execution
    2. Slow download of data or latency with the connection.

    Either way, it is the server-side script or the database that would need to be improved, not DataTables on the client-side.

    How long are the responses from the server?

    Allan

  • alfredone1alfredone1 Posts: 2Questions: 1Answers: 0

    it's ok allan thank you so much the same for answer me but i have find the solution adding on database some index and fulltext

This discussion has been closed.