Mercurial > repos > saskia-hiltemann > ireport

diff DataTables-1.9.4/media/unit_testing/performance/large.php @ 0:ac5f9272033b draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first upload
author saskia-hiltemann
date Tue, 01 Jul 2014 11:42:23 -0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/DataTables-1.9.4/media/unit_testing/performance/large.php	Tue Jul 01 11:42:23 2014 -0400
@@ -0,0 +1,108 @@
+<?php
+  /* MySQL connection */
+	include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysql.php" ); /* ;-) */
+	
+	$gaSql['link'] =  mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password']  ) or
+		die( 'Could not open connection to server' );
+	
+	mysql_select_db( $gaSql['db'], $gaSql['link'] ) or 
+		die( 'Could not select database '. $gaSql['db'] );
+
+?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
+<html>
+	<head>
+		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
+		<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico" />
+		
+		<title>DataTables example</title>
+		<style type="text/css" title="currentStyle">
+			@import "../../css/demo_page.css";
+			@import "../../css/demo_table.css";
+		</style>
+		<script type="text/javascript" language="javascript" src="../../js/jquery.js"></script>
+		<script type="text/javascript" language="javascript" src="../../js/jquery.dataTables.js"></script>
+		<script type="text/javascript" charset="utf-8">
+			$(document).ready(function() {
+				var oTable = $('#example').dataTable();
+				var iStart = new Date().getTime();
+				
+				//if ( typeof console != 'undefined' ) {
+				//	console.profile();
+				//}
+				for ( var i=0 ; i<10 ; i++ )
+				{
+					var oTable = $('#example').dataTable({"bDestroy": true});
+				}
+				//if ( typeof console != 'undefined' ) {
+				//	console.profileEnd();
+				//}
+				
+				//oTable.fnSort( [[ 1, 'asc' ]] );
+				//oTable.fnSort( [[ 1, 'asc' ]] );
+				//oTable.fnSort( [[ 2, 'asc' ]] );
+				//oTable.fnSort( [[ 1, 'asc' ]] );
+				//oTable.fnSort( [[ 2, 'asc' ]] );
+				
+				var iEnd = new Date().getTime();
+				document.getElementById('output').innerHTML = "Test took "+(iEnd-iStart)+" mS";
+			} );
+		</script>
+	</head>
+	<body id="dt_example">
+		<div id="container">
+			<div class="full_width big">
+				<i>DataTables</i> performance test - draw
+			</div>
+			<div id="output"></div>
+
+			<div id="demo">
+<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
+	<thead>
+		<tr>
+			<th>id</th>
+			<th>name</th>
+			<th>phone</th>
+			<th>email</th>
+			<th>city</th>
+			<th>zip</th>
+			<th>state</th>
+			<th>country</th>
+			<th>zip2</th>
+		</tr>
+	</thead>
+	<tbody>
+<?php
+	$sQuery = "
+		SELECT *
+		FROM   testData
+		LIMIT  2000
+	";
+	$rResult = mysql_query( $sQuery, $gaSql['link'] ) or die(mysql_error());
+	while ( $aRow = mysql_fetch_array( $rResult ) )
+	{
+		echo '<tr>';
+		echo '<td><a href="1">'.$aRow['id'].'</a></td>';
+		echo '<td>'.$aRow['name'].'</td>';
+		echo '<td>'.$aRow['phone'].'</td>';
+		echo '<td>'.$aRow['email'].'</td>';
+		echo '<td>'.$aRow['city'].'</td>';
+		echo '<td>'.$aRow['zip'].'</td>';
+		echo '<td>'.$aRow['state'].'</td>';
+		echo '<td>'.$aRow['country'].'</td>';
+		echo '<td>'.$aRow['zip2'].'</td>';
+		echo '</tr>';
+	}
+?>
+	</tbody>
+</table>
+			</div>
+			<div class="spacer"></div>
+			
+			<div id="footer" style="text-align:center;">
+				<span style="font-size:10px;">
+					DataTables &copy; Allan Jardine 2008-2009.
+				</span>
+			</div>
+		</div>
+	</body>
+</html>
\ No newline at end of file