Changes between Version 10 and Version 11 of WiMAX/30/05

Timestamp:

Feb 9, 2012, 7:05:43 PM (12 years ago)

Author:

Nilanjan Paul

Comment:

—

WiMAX/30/05

@@ -148 +148 @@
  4. kBperS ----> throughput in kilobytes per second
 
-To view the contents of the database file: '''sqlite3 values.db ".dump" '''
+To view the contents of the database file: '''sqlite3 -header -column values.db "select * from t1" '''
 {{{
-nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 values.db ".dump"
-PRAGMA foreign_keys=OFF;
-BEGIN TRANSACTION;
-CREATE TABLE t1 (t1key INTEGER PRIMARY KEY, atten INTEGER, nBytes INTEGER, time INTEGER, kBperS FLOAT);
-INSERT INTO "t1" VALUES(1,0,10878976,10.0952429920435,8419.01478418953);
-INSERT INTO "t1" VALUES(2,5,11141120,10.2252359986305,8512.2729697053);
-INSERT INTO "t1" VALUES(3,10,11010048,10.1255509853363,8494.94512689406);
-INSERT INTO "t1" VALUES(4,15,11010048,10.1354229897261,8486.67096451635);
-INSERT INTO "t1" VALUES(5,20,2097152,12.675085991621,1292.61450461408);
-INSERT INTO "t1" VALUES(6,0,2097152,12.675085991621,1292.61450461408);
-INSERT INTO "t1" VALUES(7,5,2097152,12.675085991621,1292.61450461408);
-INSERT INTO "t1" VALUES(8,10,2097152,12.675085991621,1292.61450461408);
-INSERT INTO "t1" VALUES(9,15,2097152,12.675085991621,1292.61450461408);
-INSERT INTO "t1" VALUES(10,20,2097152,12.675085991621,1292.61450461408);
+nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header -column values.db "select * from t1"
+t1key       atten       nBytes      time              kBperS
+----------  ----------  ----------  ----------------  ----------------
+1           0           10878976    10.0952429920435  8419.01478418953
+2           5           11141120    10.2252359986305  8512.2729697053
+3           10          11010048    10.1255509853363  8494.94512689406
+4           15          11010048    10.1354229897261  8486.67096451635
+5           20          2097152     12.675085991621   1292.61450461408
+6           0           2097152     12.675085991621   1292.61450461408
+7           5           2097152     12.675085991621   1292.61450461408
+8           10          2097152     12.675085991621   1292.61450461408
+9           15          2097152     12.675085991621   1292.61450461408
+10          20          2097152     12.675085991621   1292.61450461408
 }}}
 
-We can use R studio to 
+We can use R studio to analyze the data. So first dump the contents out to a file.
+{{{
+nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header values.db "select * from t1" > data.tmp
+nilanjan@console.sb4:~/exp/dl-iperf/5.2$ more data.tmp
+t1key|atten|nBytes|time|kBperS
+1|0|10878976|10.0952429920435|8419.01478418953
+2|5|11141120|10.2252359986305|8512.2729697053
+3|10|11010048|10.1255509853363|8494.94512689406
+4|15|11010048|10.1354229897261|8486.67096451635
+5|20|2097152|12.675085991621|1292.61450461408
+6|0|2097152|12.675085991621|1292.61450461408
+7|5|2097152|12.675085991621|1292.61450461408
+8|10|2097152|12.675085991621|1292.61450461408
+9|15|2097152|12.675085991621|1292.61450461408
+10|20|2097152|12.675085991621|1292.61450461408
+11|0|11010048|10.100084990263|8516.36397940451
+12|0|11010048|10.1232209950686|8496.90034840705
+13|0|11141120|10.2302289903164|8508.11844802196
+14|0|11141120|10.2948209941387|8454.73661460998
+15|5|11010048|10.1497679948807|8474.67646978575
+16|10|11141120|10.2250469923019|8512.43031602002
+17|15|10878976|10.1348799914122|8386.08844623893
+18|20|1179648|10.5095049887896|876.92046483927
+19|0|11010048|10.125388994813|8495.08103284368
+20|5|9043968|10.2897919863462|6866.61111262068
+}}}
+
 
 == Trouble shooting & miscellaneous info ==