Out Of Memory issue

nickolojon

Hi, im experiencing this issue "Out of Memory at line: 2" in jquery datatable, how can I resolve this issue? Im loading the data asynchronously using WCF REST and adding one data at a time using fnAddData then using fnStandingRedraw to display the newly created row. By the way im also implementing the column filtering function of the table here.

allan

Can you link use to your page please? Also, how many rows and columns are in your table? What kind of processing are you using? What's your data source? (we need a bit more information to be of any help :-) ).

Allan

nickolojon

Hi allan it is a search page, it can return maybe a thousand rows or more, as for the number of columns it can have a maximum of 21 columns. As for the kind of processing, I initialized the table without data in it, then i call a WCF web service and it returns a single search result in a form of json, then from that json object i created an array so that it will fit into the number of colunms displayed as it was designed to be dynamic. After building an array i used it for the fnAddData then called fnStandingRedraw. After all the search result was displayed I will now call the columnFilter function.

allan

And when you call fnAddData, I presume you are calling it with the second parameter as false to stop it redrawing?

Allan

nickolojon

Yes allan, the fnStandingRedraw will redraw the table so that even when the user uses pagination, it will not go back to the first page when an item is added to the table. Will it cause a problem? Can this process handle thousands of records? or will it result to memory leaks and showing the out of memory error.

allan

No it should be no problem, and there should be no memory leaks in fnStandingRedraw (I'd be really surprised if there were).

I'd suggest running the profiler in Chrome to see where the memory is being leaked.

Allan

nickolojon

Hi Allan,

I cant execute my solution in chrome, the WCF service is not working there for some reason. I also tried downloading "drip", but same results. Is there any other way to monitor the usage in memory of the datatable and the plugin column filtering?