close Warning: Can't synchronize with repository "(default)" (/common/SVN/wimax does not appear to be a Subversion repository.). Look in the Trac log for more information.

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


Ignore:
Timestamp:
Feb 9, 2012, 7:05:43 PM (9 years ago)
Author:
Nilanjan Paul
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • WiMAX/30/05

    v10 v11  
    148148 4. kBperS ----> throughput in kilobytes per second
    149149
    150 To view the contents of the database file: '''sqlite3 values.db ".dump" '''
     150To view the contents of the database file: '''sqlite3 -header -column values.db "select * from t1" '''
    151151{{{
    152 nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 values.db ".dump"
    153 PRAGMA foreign_keys=OFF;
    154 BEGIN TRANSACTION;
    155 CREATE TABLE t1 (t1key INTEGER PRIMARY KEY, atten INTEGER, nBytes INTEGER, time INTEGER, kBperS FLOAT);
    156 INSERT INTO "t1" VALUES(1,0,10878976,10.0952429920435,8419.01478418953);
    157 INSERT INTO "t1" VALUES(2,5,11141120,10.2252359986305,8512.2729697053);
    158 INSERT INTO "t1" VALUES(3,10,11010048,10.1255509853363,8494.94512689406);
    159 INSERT INTO "t1" VALUES(4,15,11010048,10.1354229897261,8486.67096451635);
    160 INSERT INTO "t1" VALUES(5,20,2097152,12.675085991621,1292.61450461408);
    161 INSERT INTO "t1" VALUES(6,0,2097152,12.675085991621,1292.61450461408);
    162 INSERT INTO "t1" VALUES(7,5,2097152,12.675085991621,1292.61450461408);
    163 INSERT INTO "t1" VALUES(8,10,2097152,12.675085991621,1292.61450461408);
    164 INSERT INTO "t1" VALUES(9,15,2097152,12.675085991621,1292.61450461408);
    165 INSERT INTO "t1" VALUES(10,20,2097152,12.675085991621,1292.61450461408);
     152nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header -column values.db "select * from t1"
     153t1key       atten       nBytes      time              kBperS
     154----------  ----------  ----------  ----------------  ----------------
     1551           0           10878976    10.0952429920435  8419.01478418953
     1562           5           11141120    10.2252359986305  8512.2729697053
     1573           10          11010048    10.1255509853363  8494.94512689406
     1584           15          11010048    10.1354229897261  8486.67096451635
     1595           20          2097152     12.675085991621   1292.61450461408
     1606           0           2097152     12.675085991621   1292.61450461408
     1617           5           2097152     12.675085991621   1292.61450461408
     1628           10          2097152     12.675085991621   1292.61450461408
     1639           15          2097152     12.675085991621   1292.61450461408
     16410          20          2097152     12.675085991621   1292.61450461408
    166165}}}
    167166
    168 We can use R studio to
     167We can use R studio to analyze the data. So first dump the contents out to a file.
     168{{{
     169nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header values.db "select * from t1" > data.tmp
     170nilanjan@console.sb4:~/exp/dl-iperf/5.2$ more data.tmp
     171t1key|atten|nBytes|time|kBperS
     1721|0|10878976|10.0952429920435|8419.01478418953
     1732|5|11141120|10.2252359986305|8512.2729697053
     1743|10|11010048|10.1255509853363|8494.94512689406
     1754|15|11010048|10.1354229897261|8486.67096451635
     1765|20|2097152|12.675085991621|1292.61450461408
     1776|0|2097152|12.675085991621|1292.61450461408
     1787|5|2097152|12.675085991621|1292.61450461408
     1798|10|2097152|12.675085991621|1292.61450461408
     1809|15|2097152|12.675085991621|1292.61450461408
     18110|20|2097152|12.675085991621|1292.61450461408
     18211|0|11010048|10.100084990263|8516.36397940451
     18312|0|11010048|10.1232209950686|8496.90034840705
     18413|0|11141120|10.2302289903164|8508.11844802196
     18514|0|11141120|10.2948209941387|8454.73661460998
     18615|5|11010048|10.1497679948807|8474.67646978575
     18716|10|11141120|10.2250469923019|8512.43031602002
     18817|15|10878976|10.1348799914122|8386.08844623893
     18918|20|1179648|10.5095049887896|876.92046483927
     19019|0|11010048|10.125388994813|8495.08103284368
     19120|5|9043968|10.2897919863462|6866.61111262068
     192}}}
     193
    169194
    170195== Trouble shooting & miscellaneous info ==