pl/sql in asp

soleah

Not new but not an expert.

I have an sql script in my asp webpage to pull the data and display it using datatables. This is working fine except when dealing with large data. It's giving a warning about browser slowing down or becoming unresponsive.

What is the best solution, other than writing a server-side script?

allan

If you are loading it as Ajax sourced data, enable deferred rendering for a huge speed boost: http://datatables.net/release-datatables/examples/ajax/defer_render.html . If its client-side, then... probably switch to Ajax source loading :-). There are other ways - you can turn of filtering or sorting for example - but at some point it will become too much for the browser. How many rows are you dealing with?

Allan

soleah

Around 4,000.

I'll probably try the ajax source loading first and see.

Thank you!