Client side pagnation for SQL encrypted columns

pranitdon

I am using JQuery datatables for client side. I have one encrypted column in database by using SQL encryption and I am decrypting the column using View selection.
The problem is that it takes time for data to be loaded on the client DataTables. For largedata, it gives me a Request Timeout error.
Is there a way I can load data fast so I can be able to use Sorting, searching on DataTables.?
I tried using Server-side pagination returning Json data, but the searching and Sorting is not working for Encrypted column.
I can apply search and sort on other columns (un-encrypted). I just have a problem with Encrypted columns

allan

Is there a way I can load data fast so I can be able to use Sorting, searching on DataTables.?

I think you'd probably need to consult you SQL server's documentation on how to optimise this sort of request. I'm afraid all I can really suggest is to use server-side processing and update the demo script to allow it to work with encrypted columns. Not that useful I know...

Allan