Load localdata with ServerSide=true. Problem with Out Of Memory

Load localdata with ServerSide=true. Problem with Out Of Memory

alr1976alr1976 Posts: 4Questions: 1Answers: 0

Hi!

I need to load local data to datatables. It is Possible?

i have more than 100k record....

i use "data": [

]

in ('#example').dataTable

but i got out of Memory

Answers

  • kthorngrenkthorngren Posts: 20,139Questions: 26Answers: 4,735

    You could try deferRender but likely you will need to implement Server side processing. Not sure what you mean by local data but you will need to use a server script that supports the Server side processing protocol via Ajax. Also see this FAQ.

    Kevin

  • alr1976alr1976 Posts: 4Questions: 1Answers: 0

    Thanks

    i see deferrender
    $('#example').dataTable( {
    "ajax": "sources/arrays.txt",
    "deferRender": true

    i have array.txt in my c:\temp so how can i use array.txt in my c:\temp ?
    Br Alessandro

  • kthorngrenkthorngren Posts: 20,139Questions: 26Answers: 4,735

    You will need to setup a web server to return the array.txt. Web browsers, for security reasons, won't allow ajax request to local file resources. You must use a web server even if the file is local.

    Kevin

  • alr1976alr1976 Posts: 4Questions: 1Answers: 0

    Thank you!

    do you have a small example so i can test it?

    Br Alessandro

  • kthorngrenkthorngren Posts: 20,139Questions: 26Answers: 4,735

    Are you asking for a small example of a web server? It would depend on your platform. Stack Overflow would be a good resource for learning what to use and how to set it up.

    Or are you asking for ajax examples, like these?

    Kevin

Sign In or Register to comment.