sqlite: SQL code runs slower on each iteration in Chrome if ASYNCIFY and IDBFS are used
leopatras
emcc \
-s MAIN_MODULE=1 \
-O2 \
-s EXPORT_ALL=1 \
-s EXIT_RUNTIME=1 \
-s ASSERTIONS=1 \
-s FORCE_FILESYSTEM=1 \
-s ALLOW_MEMORY_GROWTH=1 \
-s ASYNCIFY \
-lidbfs.js \
-o main.html $(OBJS)
#include <stdio.h>
#include <stdlib.h>
#include <sys/time.h>
#include <emscripten.h>
#include "sqlite3.h"
EM_JS(char*,addPersistentDirsInt,(),{
const dirname="/persist";
try {
FS.mkdir(dirname);
} catch(err) {
console.error("mkdir %o failed:%o",dirname,err);
return;
}
try {
FS.mount(IDBFS, { autoPersist: true }, dirname);
console.log("did mount IDBFS to "+dirname);
} catch (err) {
console.error("mount(IDBFS,{ autoPersist: true },%o) error:%o",dirname,err);
}
});
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
NotUsed = 0;
/*
int i;
for (i = 0; i < argc; i++) {
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
*/
return 0;
}
int main(int argc, char **argv)
{
sqlite3 *db;
char *err = 0;
int rc,i,loop;
struct timeval stop, start;
addPersistentDirsInt();
for (loop = 1; loop <= 20; loop++) {
gettimeofday(&start, NULL);
remove("/persist/test.db");
rc = sqlite3_open("/persist/test.db", &db);
if (rc == SQLITE_OK) {
rc = sqlite3_exec(db,
"CREATE TABLE test (id INTEGER NOT NULL, text VARCHAR(100))",
callback, 0, &err);
if (rc != SQLITE_OK) {
fprintf(stderr, "SQL error CREATE: %s\n", err);
}
for (i = 1; i < 100; i++) {
char buf[500];
sprintf(buf, "INSERT INTO test VALUES (%d, 'text%d')", i,
i);
rc = sqlite3_exec(db, buf, callback, 0, &err);
if (rc != SQLITE_OK) {
fprintf(stderr, "SQL error INSERT: %s\n", err);
}
}
rc = sqlite3_exec(db, "SELECT * FROM test", callback, 0, &err);
if (rc != SQLITE_OK) {
fprintf(stderr, "SQL error SELECT: %s\n", err);
}
rc = sqlite3_exec(db, "DELETE FROM test", callback, 0, &err);
if (rc != SQLITE_OK) {
fprintf(stderr, "SQL error DELETE: %s\n", err);
}
rc = sqlite3_exec(db, "DROP TABLE test", callback, 0, &err);
if (rc != SQLITE_OK) {
fprintf(stderr, "SQL error DROP: %s\n", err);
}
sqlite3_close(db);
gettimeofday(&stop, NULL);
printf("loop:%d db ops took %lld msec\n",loop,
(stop.tv_sec - start.tv_sec) * 1000000 + stop.tv_usec -
start.tv_usec);
} else {
fprintf(stderr, "Can't open database: %s\n",
sqlite3_errmsg(db));
sqlite3_close(db);
return 1;
}
}
return 0;
}
Sam Clegg
--
You received this message because you are subscribed to the Google Groups "emscripten-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to emscripten-disc...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/emscripten-discuss/fb7330e6-399c-4db6-ad83-bbaeafe13c51n%40googlegroups.com.
Alon Zakai
That does sound rather strange.Can you also reproduce if you remove `-sMAIN_MODULE=1` and `-sALLOW_MEMORY_GROWTH`?Is the IDBFS storage growing on each iteration? Can you tell where the slowdown is happening exactly?
To view this discussion visit https://groups.google.com/d/msgid/emscripten-discuss/CAL_va2_GN--vB0V_zXMQ62gLtoh3qBzz8xNRMdieCaqDQ%3DY8KQ%40mail.gmail.com.
Leo Schubert
It seems that operations take more time over time (I did focus on the close here), so one shot is some seconds taken before the other one and execution time did double from 0.1msec to 0.2msec
