bulk data from database slows everything

bulk data from database slows everything

AjayLakhanAjayLakhan Posts: 1Questions: 0Answers: 0
edited December 2011 in General
I am trying below example with IE7,IE8, firefox 8.0.1, google chrome. It works somehow fine with chrome and firefox but not good with IE 7/8. I got ArrayList values from servlet. database records may be more than 20000.

Is it possible to find any example on JSP/Servlets with datatables(server-side processing) rather than in below link:
http://www.codeproject.com/KB/java/JQuery-DataTables-Java.aspx


<%@page import="java.util.ListIterator"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">;
<%@page import="com.model.DataManager"%>
<%@ page import="java.util.ArrayList"%>
<%@ page import="com.beans.UserBean"%>



Admin


@import "<%=request.getContextPath()%>/media/css/demo_page.css";
@import "<%=request.getContextPath()%>/media/css/TableTools.css";
@import "<%=request.getContextPath()%>/media/css/demo_table_jui.css";
@import "<%=request.getContextPath()%>/themes/ui-lightness/jquery-ui-1.8.4.custom.css";







$(document).ready(function() {
$('#tabledata').dataTable({
"bAutoWidth": false,
"bProcessing": false,
"bSortClasses": false,
"sDom": '<"H"Tlfr>t<"F"ip>'
});
});



<%
UserBean userBean=(UserBean)session.getAttribute("userBean");
ArrayList userbeanArr=(ArrayList)session.getAttribute("dataArr");
%>







Param1
Param2
Param3
Param4
Param5



<%
ListIterator listIter = userbeanArr.listIterator();
while(listIter.hasNext())
{
userBean = (UserBean)listIter.next();
%>

<%= userBean.getParam1() %>
<%= userBean.getParam2() %>
<%= userBean.getParam3() %>
<%= userBean.getParam4() %>
<%= userBean.getParam5() %>

<%}%>

Replies

  • allanallan Posts: 63,139Questions: 1Answers: 10,400 Site admin
    12'000+ records in a static table is going to kill IE...! You will indeed want to go with either server-side processing or referred rendering from an Ajax load (which is easier to implement than server-side processing).

    There are a number of demo server-side processing scripts available here, including a JSP one: http://datatables.net/development/server-side/

    Allan
This discussion has been closed.