Urgent help regarding table size and aoColumnDefs
Urgent help regarding table size and aoColumnDefs
Sapan
Posts: 2Questions: 0Answers: 0
hello
I am creating simple table with one fixed columns.
When the column length is 1300 then it takes 5min to lead and if i remove the aoColumnDefs part then it doesnot work..
##########################################
/*----------Text Styles----------*/
.ws6 {font-size: 8px;}
.ws7 {font-size: 9.3px;}
.ws8 {font-size: 11px;}
.ws9 {font-size: 12px;}
.ws10 {font-size: 13px;}
.ws11 {font-size: 15px;}
.ws12 {font-size: 16px;}
.ws14 {font-size: 19px;}
.ws16 {font-size: 21px;}
.ws18 {font-size: 24px;}
.ws20 {font-size: 27px;}
.ws22 {font-size: 29px;}
.ws24 {font-size: 32px;}
.ws26 {font-size: 35px;}
.ws28 {font-size: 37px;}
.ws36 {font-size: 48px;}
.ws48 {font-size: 64px;}
.ws72 {font-size: 96px;}
.wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;}
/*----------Para Styles----------*/
DIV,UL,OL /* Left */
{
margin-top: 0px;
margin-bottom: 0px;
}
div#container
{
position:relative;
width: 1000px;
margin-top: 0px;
margin-left: auto;
margin-right: auto;
text-align:left;
}
body {text-align:center;margin:0}
@import ".js/demo_page.css";
@import "./js/demo_table.css";
tr { height: 30px; }
$(document).ready( function () {
var iStart = new Date().getTime();
var oTable = $('#example').dataTable( {
"sScrollY": "100px",
"sScrollX": "500px",
//"sScrollXInner": "100%",
"bScrollCollapse": true,
"bPaginate": false,
"bSort": false,
"bAutoWidth": false,
"aoColumnDefs": [
{ "bSortable": false, "aTargets": [ 0 ] },
{ "bSortable": false, "aTargets": [1] },
{ "bSortable": false, "aTargets": [2] },
{ "bSortable": false, "aTargets": [3] },
{ "bSortable": false, "aTargets": [4] },
{ "bSortable": false, "aTargets": [5] },
{ "bSortable": false, "aTargets": [6] },
{ "bSortable": false, "aTargets": [7] },
{ "bSortable": false, "aTargets": [8] },
]
} );
new FixedColumns( oTable, {
//"sHeightMatch": "none",
//"iLeftColumns": 1,
//"iLeftWidth": "100%"
} );
} );
SPEER_SERVER_RESULT
Column Number
0001
0002
0003
0004
0005
0006
0007
0008
Score
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
Z-Value
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
P-Value
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
PDB|1AJ0||SUB1|
-
-
-
-
-
-
-
-
######################################################################
If i remove the "aoColumnDefs" property page doesnot work.
How to provide bSortable: false property to all the columns in one line? And why datatables not working on removing "aoColumnDefs".
Regards
Sapan
I am creating simple table with one fixed columns.
When the column length is 1300 then it takes 5min to lead and if i remove the aoColumnDefs part then it doesnot work..
##########################################
/*----------Text Styles----------*/
.ws6 {font-size: 8px;}
.ws7 {font-size: 9.3px;}
.ws8 {font-size: 11px;}
.ws9 {font-size: 12px;}
.ws10 {font-size: 13px;}
.ws11 {font-size: 15px;}
.ws12 {font-size: 16px;}
.ws14 {font-size: 19px;}
.ws16 {font-size: 21px;}
.ws18 {font-size: 24px;}
.ws20 {font-size: 27px;}
.ws22 {font-size: 29px;}
.ws24 {font-size: 32px;}
.ws26 {font-size: 35px;}
.ws28 {font-size: 37px;}
.ws36 {font-size: 48px;}
.ws48 {font-size: 64px;}
.ws72 {font-size: 96px;}
.wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;}
/*----------Para Styles----------*/
DIV,UL,OL /* Left */
{
margin-top: 0px;
margin-bottom: 0px;
}
div#container
{
position:relative;
width: 1000px;
margin-top: 0px;
margin-left: auto;
margin-right: auto;
text-align:left;
}
body {text-align:center;margin:0}
@import ".js/demo_page.css";
@import "./js/demo_table.css";
tr { height: 30px; }
$(document).ready( function () {
var iStart = new Date().getTime();
var oTable = $('#example').dataTable( {
"sScrollY": "100px",
"sScrollX": "500px",
//"sScrollXInner": "100%",
"bScrollCollapse": true,
"bPaginate": false,
"bSort": false,
"bAutoWidth": false,
"aoColumnDefs": [
{ "bSortable": false, "aTargets": [ 0 ] },
{ "bSortable": false, "aTargets": [1] },
{ "bSortable": false, "aTargets": [2] },
{ "bSortable": false, "aTargets": [3] },
{ "bSortable": false, "aTargets": [4] },
{ "bSortable": false, "aTargets": [5] },
{ "bSortable": false, "aTargets": [6] },
{ "bSortable": false, "aTargets": [7] },
{ "bSortable": false, "aTargets": [8] },
]
} );
new FixedColumns( oTable, {
//"sHeightMatch": "none",
//"iLeftColumns": 1,
//"iLeftWidth": "100%"
} );
} );
SPEER_SERVER_RESULT
Column Number
0001
0002
0003
0004
0005
0006
0007
0008
Score
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
Z-Value
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
P-Value
NIL
NIL
NIL
NIL
NIL
NIL
NIL
NIL
PDB|1AJ0||SUB1|
-
-
-
-
-
-
-
-
######################################################################
If i remove the "aoColumnDefs" property page doesnot work.
How to provide bSortable: false property to all the columns in one line? And why datatables not working on removing "aoColumnDefs".
Regards
Sapan
This discussion has been closed.
Replies
You can also try to use "oaColums" instead of "aoColumnDefs".
I'm not a datatables expert, do not delude yourself if mine isn't a "final" solution.