What's the limit of amount of data a dataTable can display?

gh2m

I have a datatable that pulls over 7,000 rows (5 columns) without any issue. Now I have another datatable with less than 6,000 rows but 14 columns. It stopped pulling any rows at 2313 rows. Why is that? Following is my datatable definition:

var table = $('#example').DataTable( {
            data: dataSet,
            columns: [
                { title: "Column 1" },
                { title: "Column 2" },
                ......,
                { title: "Column 14" }
            ],
        "deferRender": true,
        "orderClasses": false
        } );

My dataSet is generated from a SQL table:
<script>
    $(document).ready(function() {
        var dataSet = [
            ["col1 data","col2 data", ......, "col14 data"],
                        ......
                        [......]
                ]
        });
</script>

Edited by Kevin:  Syntax highlighting. Details on how to highlight code using markdown can be found in this guide

kthorngren

Datatatables doesn't limit the data. Start by verifying the length of dataSet. Check for errors in the browser's console. Validate the number of records your SQL query is generating.

Kevin

gh2m

Thanks. Yes the problem is the processing code having limitation on number of records may be return. It's all working now.