fetch 100 million datas from Database
fetch 100 million datas from Database
ramki159
Posts: 4Questions: 1Answers: 0
hi am new to data-tables i want to fetch 100 million data from my database to data-table but i am not sure is it possible ?
please Help me.
This question has accepted answers - jump to:
This discussion has been closed.
Answers
See the server-side processing manual.
Allan
Thanks allan
hi allan,
when am fetching 25000000 rows from database it takes too time to load could you help me to solve this problem i want to get the data's into data-table from my DB as much as faster
i think scroller is what you need http://datatables.net/extensions/scroller/
Using server-side processing you should only be fetching 10 rows at a time (or how ever large your page size is). I would suggest reading over the documentation page I linked to again if you are returning all of the rows in a single request.
Allan
hi allan
i was confused with documentation could you give me any example link for reference plz...
Example with full code is here:
http://datatables.net/examples/data_sources/server_side.html