performance

flovera

Hello Allan I need your help again. The thing is that I have a huge datatable (with 8042 rows) and it gets pretty slow. I followed the specifications here: http://datatables.net/usage/features

But I dont get a much better result. I need to get the exports (in xls), and search options, so please if you have any other configuration that helps to get a faster datatable, let me know.

Thanks.

flovera

Im trying to use this:
http://datatables.net/release-datatables/examples/data_sources/server_side.html
http://datatables.net/usage/server-side

But I really dont follow the indications above. Im using JSP and in my entire project I dont use ajax.
Soo, I could change the ajax part, but not the jsp. Please, if there is another method tell me.

allan

8042 rows really isn't that many. Can you link to a test case showing the issue please? Is it just the xls export which is slow? If so, I'm not sure much can be done about that I'm afraid - the Flash / Javascript bridge isn't the fastest int he work and the Flash script converts the UTF8 data to UTF16-LE for Excel, which is also a very slow process.

Allan

flovera

I cant do that, because you would be viewing private data. Sorry about that; But if this can give you a better idea of what's going on: Here is a message that the browser gives me:

A script on this page may be busy, or it may have stopped responding. You can stop the script now, or you can continue to see if the script will complete.

Script: http://code.jquery.com/jquery-1.8.0.min.js:2

Do you have any idea? I think that the code is getting stock in some where.

allan

I'm afraid that without a link I'd really be guessing, and I don't even know where to being in this case. You say you are using server-side processing - how many rows are being returned at once? How long does the Ajax return take? Do you do any post processing on the data? Any callbacks? As I say, I'm just guessing I'm afraid.

Allan

flovera

I'm afraid I'm screwed. I don't not how to use the combination between Ajax and JSP.

Hard problem isn't it?!

allan

I'm afraid I don't know JSP at all - I can't really help in that regard. All I can help with is on the client-side, in DataTables specifically.

Allan