FilesExpand file tree

 sqlite3_update_hook

/

insert.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

68 lines (57 loc) · 2.02 KB

 sqlite3_update_hook

/

insert.js

Copy path

Top

File metadata and controls

• Code
• Blame

68 lines (57 loc) · 2.02 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

var sqlite3 = require('../../lib/sqlite3');

var fs = require('fs');

var iterations = 10000;

exports.compare = {

'insert literal file': function(finished) {

var db = new sqlite3.Database('');

var file = fs.readFileSync('benchmark/insert-transaction.sql', 'utf8');

db.exec(file);

db.close(finished);

},

'insert with transaction and two statements': function(finished) {

var db = new sqlite3.Database('');

db.serialize(function() {

db.run("CREATE TABLE foo (id INT, txt TEXT)");

db.run("BEGIN");

db.parallelize(function() {

var stmt1 = db.prepare("INSERT INTO foo VALUES (?, ?)");

var stmt2 = db.prepare("INSERT INTO foo VALUES (?, ?)");

for (var i = 0; i < iterations; i++) {

stmt1.run(i, 'Row ' + i);

i++;

stmt2.run(i, 'Row ' + i);

}

stmt1.finalize();

stmt2.finalize();

});

db.run("COMMIT");

});

db.close(finished);

},

'insert with transaction': function(finished) {

var db = new sqlite3.Database('');

db.serialize(function() {

db.run("CREATE TABLE foo (id INT, txt TEXT)");

db.run("BEGIN");

var stmt = db.prepare("INSERT INTO foo VALUES (?, ?)");

for (var i = 0; i < iterations; i++) {

stmt.run(i, 'Row ' + i);

}

stmt.finalize();

db.run("COMMIT");

});

db.close(finished);

},

'insert without transaction': function(finished) {

var db = new sqlite3.Database('');

db.serialize(function() {

db.run("CREATE TABLE foo (id INT, txt TEXT)");

var stmt = db.prepare("INSERT INTO foo VALUES (?, ?)");

for (var i = 0; i < iterations; i++) {

stmt.run(i, 'Row ' + i);

}

stmt.finalize();

});

db.close(finished);

}

};