I have a DataTable and I would like to display data over several pages. I would like pages with 100 elements on each. In addition I would like to have some of my columns sortable.
In my Database I have more than 100 elements and my DataTable is only showing the first 100...

I've noticed some things :

1) When I put **"bServerSide": false** my columns are sortable ***BUT*** my number of rows is limited to 100 (one page with 100 elements).

2) When I put **"bServerSide": true** my number of rows is now correct (several pages with 100 elements on each) ***BUT*** my columns are not sortable anymore (I mean the sort function doesn't work when I click on the sort button).

```
$('#tableSupervisionElecteur').DataTable({  
        "bLengthChange" : false,
        "bFilter" : false,
        "bProcessing": false,
        "searching": false,
        "ordering":  true,
        "order": [[1, 'asc']],
        "bStateSave": false,
        "pageLength": 100,
        "iDisplayStart": 0,
        "bServerSide": true,
        "initComplete": function(settings, json) {

        },
        "fnDrawCallback": function () {

        },         
        "sAjaxSource": "sourcesDataTables",

        "aoColumns": [
            ...
        ],
        columnDefs: [
                {
                    orderable: false,
                    targets: 0
                },
                {
                    orderable: false,
                    targets: 7
                },
                {
                    orderable: false,
                    targets: 8
                },
                ]
    });

```

I would like to have BOTH features working together (sorting and displaying) and not one or the other.

Furthermore my DataTable needs to be able to handle approximately 30 000 rows.