mirror of
https://github.com/sqlite/sqlite.git
synced 2024-11-24 16:18:08 +01:00
373 lines
15 KiB
HTML
373 lines
15 KiB
HTML
<!doctype html>
|
|
<html lang="en-us">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|
<link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon">
|
|
<link rel="stylesheet" href="common/emscripten.css"/>
|
|
<link rel="stylesheet" href="common/testing.css"/>
|
|
<title>speedtest1.wasm Worker</title>
|
|
</head>
|
|
<body>
|
|
<header id='titlebar'>speedtest1.wasm Worker</header>
|
|
<div>See also: <a href='speedtest1.html'>A main-thread variant of this page.</a></div>
|
|
<!-- emscripten bits -->
|
|
<figure id="module-spinner">
|
|
<div class="spinner"></div>
|
|
<div class='center'><strong>Initializing app...</strong></div>
|
|
<div class='center'>
|
|
On a slow internet connection this may take a moment. If this
|
|
message displays for "a long time", intialization may have
|
|
failed and the JavaScript console may contain clues as to why.
|
|
</div>
|
|
</figure>
|
|
<div class="emscripten" id="module-status">Downloading...</div>
|
|
<div class="emscripten">
|
|
<progress value="0" max="100" id="module-progress" hidden='1'></progress>
|
|
</div><!-- /emscripten bits -->
|
|
<fieldset id='ui-controls' class='hidden'>
|
|
<legend>Options</legend>
|
|
<div id='toolbar'>
|
|
<div id='toolbar-select'>
|
|
<select id='select-flags' size='10' multiple></select>
|
|
<div>The following flags can be passed as URL parameters:
|
|
vfs=NAME, size=N, journal=MODE, cachesize=SIZE
|
|
</div>
|
|
</div>
|
|
<div class='toolbar-inner-vertical'>
|
|
<div id='toolbar-selected-flags'></div>
|
|
<div class='toolbar-inner-vertical'>
|
|
<span>→ <a id='link-main-thread' href='#' target='speedtest-main'
|
|
title='Start speedtest1.html with the selected flags'>speedtest1</a>
|
|
</span>
|
|
<span class='hidden'>→ <a id='link-wasmfs' href='#' target='speedtest-wasmfs'
|
|
title='Start speedtest1-wasmfs.html with the selected flags'>speedtest1-wasmfs</a>
|
|
</span>
|
|
<span>→ <a id='link-kvvfs' href='#' target='speedtest-kvvfs'
|
|
title='Start kvvfs speedtest1 with the selected flags'>speedtest1-kvvfs</a>
|
|
</span>
|
|
</div>
|
|
</div>
|
|
<div class='toolbar-inner-vertical' id='toolbar-runner-controls'>
|
|
<button id='btn-reset-flags'>Reset Flags</button>
|
|
<button id='btn-output-clear'>Clear output</button>
|
|
<button id='btn-run'>Run</button>
|
|
</div>
|
|
</div>
|
|
</fieldset>
|
|
<div>
|
|
<span class='input-wrapper'>
|
|
<input type='checkbox' class='disable-during-eval' id='cb-reverse-log-order' checked></input>
|
|
<label for='cb-reverse-log-order' id='lbl-reverse-log-order'>Reverse log order</label>
|
|
</span>
|
|
</div>
|
|
<div id='test-output'>
|
|
</div>
|
|
<div id='tips'>
|
|
<strong>Tips:</strong>
|
|
<ul>
|
|
<li>Control-click the flags to (de)select multiple flags.</li>
|
|
<li>The <tt>--big-transactions</tt> flag is important for two
|
|
of the bigger tests. Without it, those tests create many
|
|
thousands of implicit transactions, reducing the affected
|
|
tests to an absolute crawl, in particular with OPFS.
|
|
</li>
|
|
<li>The easiest way to try different optimization levels is,
|
|
from this directory:
|
|
<pre>$ rm -f jswasm/speedtest1.js; make -e emcc_opt='-O2' speedtest1</pre>
|
|
Then reload this page. -O2 seems to consistently produce the fastest results.
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
<style>
|
|
#test-output {
|
|
white-space: break-spaces;
|
|
overflow: auto;
|
|
}
|
|
div#tips { margin-top: 1em; }
|
|
#toolbar {
|
|
display: flex;
|
|
flex-direction: row;
|
|
flex-wrap: wrap;
|
|
}
|
|
#toolbar > * {
|
|
margin: 0 0.5em;
|
|
}
|
|
.toolbar-inner-vertical {
|
|
display: flex;
|
|
flex-direction: column;
|
|
justify-content: space-between;
|
|
}
|
|
#toolbar-select {
|
|
display: flex;
|
|
flex-direction: column;
|
|
}
|
|
.toolbar-inner-vertical > *, #toolbar-select > * {
|
|
margin: 0.2em 0;
|
|
}
|
|
#select-flags > option {
|
|
white-space: pre;
|
|
font-family: monospace;
|
|
}
|
|
fieldset {
|
|
border-radius: 0.5em;
|
|
}
|
|
#toolbar-runner-controls { flex-grow: 1 }
|
|
#toolbar-runner-controls > * { flex: 1 0 auto }
|
|
#toolbar-selected-flags::before {
|
|
font-family: initial;
|
|
content:"Selected flags: ";
|
|
}
|
|
#toolbar-selected-flags {
|
|
display: flex;
|
|
flex-direction: column;
|
|
font-family: monospace;
|
|
justify-content: flex-start;
|
|
}
|
|
</style>
|
|
<script>(function(){
|
|
'use strict';
|
|
const E = (sel)=>document.querySelector(sel);
|
|
const eOut = E('#test-output');
|
|
const log2 = function(cssClass,...args){
|
|
let ln;
|
|
if(1 || cssClass){
|
|
ln = document.createElement('div');
|
|
if(cssClass) ln.classList.add(cssClass);
|
|
ln.append(document.createTextNode(args.join(' ')));
|
|
}else{
|
|
// This doesn't work with the "reverse order" option!
|
|
ln = document.createTextNode(args.join(' ')+'\n');
|
|
}
|
|
eOut.append(ln);
|
|
};
|
|
const log = (...args)=>{
|
|
//console.log(...args);
|
|
log2('', ...args);
|
|
};
|
|
const logErr = function(...args){
|
|
console.error(...args);
|
|
log2('error', ...args);
|
|
};
|
|
const logWarn = function(...args){
|
|
console.warn(...args);
|
|
log2('warning', ...args);
|
|
};
|
|
|
|
const spacePad = function(str,len=21){
|
|
if(str.length===len) return str;
|
|
else if(str.length>len) return str.substr(0,len);
|
|
const a = []; a.length = len - str.length;
|
|
return str+a.join(' ');
|
|
};
|
|
// OPTION elements seem to ignore white-space:pre, so do this the hard way...
|
|
const nbspPad = function(str,len=21){
|
|
if(str.length===len) return str;
|
|
else if(str.length>len) return str.substr(0,len);
|
|
const a = []; a.length = len - str.length;
|
|
return str+a.join(' ');
|
|
};
|
|
|
|
const urlParams = new URL(self.location.href).searchParams;
|
|
const W = new Worker(
|
|
"speedtest1-worker.js?sqlite3.dir=jswasm"+
|
|
(urlParams.has('opfs-verbose') ? '&opfs-verbose' : '')+
|
|
(urlParams.has('opfs-disable') ? '&opfs-disable' : '')
|
|
);
|
|
const mPost = function(msgType,payload){
|
|
W.postMessage({type: msgType, data: payload});
|
|
};
|
|
|
|
const eFlags = E('#select-flags');
|
|
const eSelectedFlags = E('#toolbar-selected-flags');
|
|
const eLinkMainThread = E('#link-main-thread');
|
|
const eLinkWasmfs = E('#link-wasmfs');
|
|
const eLinkKvvfs = E('#link-kvvfs');
|
|
const getSelectedFlags = ()=>{
|
|
const f = Array.prototype.map.call(eFlags.selectedOptions, (v)=>v.value);
|
|
[
|
|
'size', 'vfs', 'journal', 'cachesize'
|
|
].forEach(function(k){
|
|
if(urlParams.has(k)) f.push('--'+k, urlParams.get(k));
|
|
});
|
|
return f;
|
|
};
|
|
const updateSelectedFlags = function(){
|
|
eSelectedFlags.innerText = '';
|
|
const flags = getSelectedFlags();
|
|
flags.forEach(function(f){
|
|
const e = document.createElement('span');
|
|
e.innerText = f;
|
|
eSelectedFlags.appendChild(e);
|
|
});
|
|
const rxStripDash = /^(-+)?/;
|
|
const comma = flags.join(',');
|
|
eLinkMainThread.setAttribute('target', 'speedtest1-main-'+comma);
|
|
eLinkMainThread.href = 'speedtest1.html?flags='+comma;
|
|
eLinkWasmfs.setAttribute('target', 'speedtest1-wasmfs-'+comma);
|
|
eLinkWasmfs.href = 'speedtest1-wasmfs.html?flags='+comma;
|
|
eLinkKvvfs.setAttribute('target', 'speedtest1-kvvfs-'+comma);
|
|
eLinkKvvfs.href = 'speedtest1.html?vfs=kvvfs&flags='+comma;
|
|
};
|
|
eFlags.addEventListener('change', updateSelectedFlags );
|
|
{
|
|
const flags = Object.create(null);
|
|
/* TODO? Flags which require values need custom UI
|
|
controls and some of them make little sense here
|
|
(e.g. --script FILE). */
|
|
flags["--autovacuum"] = "Enable AUTOVACUUM mode";
|
|
flags["--big-transactions"] = "Important for tests 410 and 510!";
|
|
//flags["--cachesize"] = "N Set the cache size to N pages";
|
|
flags["--checkpoint"] = "Run PRAGMA wal_checkpoint after each test case";
|
|
flags["--exclusive"] = "Enable locking_mode=EXCLUSIVE";
|
|
flags["--explain"] = "Like --sqlonly but with added EXPLAIN keywords";
|
|
//flags["--heap"] = "SZ MIN Memory allocator uses SZ bytes & min allocation MIN";
|
|
flags["--incrvacuum"] = "Enable incremenatal vacuum mode";
|
|
//flags["--journal"] = "M Set the journal_mode to M";
|
|
//flags["--key"] = "KEY Set the encryption key to KEY";
|
|
//flags["--lookaside"] = "N SZ Configure lookaside for N slots of SZ bytes each";
|
|
flags["--memdb"] = "Use an in-memory database";
|
|
//flags["--mmap"] = "SZ MMAP the first SZ bytes of the database file";
|
|
flags["--multithread"] = "Set multithreaded mode";
|
|
flags["--nomemstat"] = "Disable memory statistics";
|
|
flags["--nomutex"] = "Open db with SQLITE_OPEN_NOMUTEX";
|
|
flags["--nosync"] = "Set PRAGMA synchronous=OFF";
|
|
flags["--notnull"] = "Add NOT NULL constraints to table columns";
|
|
//flags["--output"] = "FILE Store SQL output in FILE";
|
|
//flags["--pagesize"] = "N Set the page size to N";
|
|
//flags["--pcache"] = "N SZ Configure N pages of pagecache each of size SZ bytes";
|
|
//flags["--primarykey"] = "Use PRIMARY KEY instead of UNIQUE where appropriate";
|
|
//flags["--repeat"] = "N Repeat each SELECT N times (default: 1)";
|
|
flags["--reprepare"] = "Reprepare each statement upon every invocation";
|
|
//flags["--reserve"] = "N Reserve N bytes on each database page";
|
|
//flags["--script"] = "FILE Write an SQL script for the test into FILE";
|
|
flags["--serialized"] = "Set serialized threading mode";
|
|
flags["--singlethread"] = "Set single-threaded mode - disables all mutexing";
|
|
flags["--sqlonly"] = "No-op. Only show the SQL that would have been run.";
|
|
flags["--shrink-memory"] = "Invoke sqlite3_db_release_memory() frequently.";
|
|
//flags["--size"] = "N Relative test size. Default=100";
|
|
flags["--strict"] = "Use STRICT table where appropriate";
|
|
flags["--stats"] = "Show statistics at the end";
|
|
//flags["--temp"] = "N N from 0 to 9. 0: no temp table. 9: all temp tables";
|
|
//flags["--testset"] = "T Run test-set T (main, cte, rtree, orm, fp, debug)";
|
|
flags["--trace"] = "Turn on SQL tracing";
|
|
//flags["--threads"] = "N Use up to N threads for sorting";
|
|
/*
|
|
The core API's WASM build does not support UTF16, but in
|
|
this app it's not an issue because the data are not crossing
|
|
JS/WASM boundaries.
|
|
*/
|
|
flags["--utf16be"] = "Set text encoding to UTF-16BE";
|
|
flags["--utf16le"] = "Set text encoding to UTF-16LE";
|
|
flags["--verify"] = "Run additional verification steps.";
|
|
flags["--without-rowid"] = "Use WITHOUT ROWID where appropriate";
|
|
const preselectedFlags = [
|
|
'--big-transactions',
|
|
'--singlethread'
|
|
];
|
|
if(urlParams.has('flags')){
|
|
preselectedFlags.push(...urlParams.get('flags').split(','));
|
|
}
|
|
if(!urlParams.get('vfs')){
|
|
preselectedFlags.push('--memdb');
|
|
}
|
|
Object.keys(flags).sort().forEach(function(f){
|
|
const opt = document.createElement('option');
|
|
eFlags.appendChild(opt);
|
|
const lbl = nbspPad(f)+flags[f];
|
|
//opt.innerText = lbl;
|
|
opt.innerHTML = lbl;
|
|
opt.value = f;
|
|
if(preselectedFlags.indexOf(f) >= 0) opt.selected = true;
|
|
});
|
|
const cbReverseLog = E('#cb-reverse-log-order');
|
|
const lblReverseLog = E('#lbl-reverse-log-order');
|
|
if(cbReverseLog.checked){
|
|
lblReverseLog.classList.add('warning');
|
|
eOut.classList.add('reverse');
|
|
}
|
|
cbReverseLog.addEventListener('change', function(){
|
|
if(this.checked){
|
|
eOut.classList.add('reverse');
|
|
lblReverseLog.classList.add('warning');
|
|
}else{
|
|
eOut.classList.remove('reverse');
|
|
lblReverseLog.classList.remove('warning');
|
|
}
|
|
}, false);
|
|
updateSelectedFlags();
|
|
}
|
|
E('#btn-output-clear').addEventListener('click', ()=>{
|
|
eOut.innerText = '';
|
|
});
|
|
E('#btn-reset-flags').addEventListener('click',()=>{
|
|
eFlags.value = '';
|
|
updateSelectedFlags();
|
|
});
|
|
E('#btn-run').addEventListener('click',function(){
|
|
log("Running speedtest1. UI controls will be disabled until it completes.");
|
|
mPost('run', getSelectedFlags());
|
|
});
|
|
|
|
const eControls = E('#ui-controls');
|
|
/** Update Emscripten-related UI elements while loading the module. */
|
|
const updateLoadStatus = function f(text){
|
|
if(!f.last){
|
|
f.last = { text: '', step: 0 };
|
|
const E = (cssSelector)=>document.querySelector(cssSelector);
|
|
f.ui = {
|
|
status: E('#module-status'),
|
|
progress: E('#module-progress'),
|
|
spinner: E('#module-spinner')
|
|
};
|
|
}
|
|
if(text === f.last.text) return;
|
|
f.last.text = text;
|
|
if(f.ui.progress){
|
|
f.ui.progress.value = f.last.step;
|
|
f.ui.progress.max = f.last.step + 1;
|
|
}
|
|
++f.last.step;
|
|
if(text) {
|
|
f.ui.status.classList.remove('hidden');
|
|
f.ui.status.innerText = text;
|
|
}else{
|
|
if(f.ui.progress){
|
|
f.ui.progress.remove();
|
|
f.ui.spinner.remove();
|
|
delete f.ui.progress;
|
|
delete f.ui.spinner;
|
|
}
|
|
f.ui.status.classList.add('hidden');
|
|
}
|
|
};
|
|
|
|
W.onmessage = function(msg){
|
|
msg = msg.data;
|
|
switch(msg.type){
|
|
case 'ready':
|
|
log("Worker is ready.");
|
|
eControls.classList.remove('hidden');
|
|
break;
|
|
case 'stdout': log(msg.data); break;
|
|
case 'stderr': logErr(msg.data); break;
|
|
case 'run-start':
|
|
eControls.disabled = true;
|
|
log("Running speedtest1 with argv =",msg.data.join(' '));
|
|
break;
|
|
case 'run-end':
|
|
log("speedtest1 finished.");
|
|
eControls.disabled = false;
|
|
// app output is in msg.data
|
|
break;
|
|
case 'error': logErr(msg.data); break;
|
|
case 'load-status': updateLoadStatus(msg.data); break;
|
|
default:
|
|
logErr("Unhandled worker message type:",msg);
|
|
break;
|
|
}
|
|
};
|
|
})();</script>
|
|
</body>
|
|
</html>
|