Created
April 27, 2012 18:41
-
-
Save Shadow6363/2511636 to your computer and use it in GitHub Desktop.
CakePHP2.1 SQLite Query Performance
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sele order from deta | |
| ---- ------------- ---- ---- | |
| 0 0 0 SEARCH TABLE documents AS CommentDocument USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) | |
| 0 1 1 SEARCH TABLE users AS DocumentUser USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) | |
| addr opcode p1 p2 p3 p4 p5 comment | |
| ---- ------------- ---- ---- ---- ------------- -- ------------- | |
| 0 Trace 0 0 0 00 | |
| 1 Integer 1 1 0 00 | |
| 2 Integer 5 2 0 00 | |
| 3 Goto 0 35 0 00 | |
| 4 OpenRead 0 10 0 9 00 | |
| 5 OpenRead 1 2 0 5 00 | |
| 6 MustBeInt 2 32 0 00 | |
| 7 NotExists 0 32 2 00 | |
| 8 Integer 0 4 0 00 | |
| 9 Column 0 1 3 00 | |
| 10 MustBeInt 3 29 0 00 | |
| 11 NotExists 1 29 3 00 | |
| 12 Integer 1 4 0 00 | |
| 13 Rowid 0 5 0 00 | |
| 14 Column 0 1 6 00 | |
| 15 Column 0 2 7 00 | |
| 16 Column 0 3 8 00 | |
| 17 Column 0 4 9 00 | |
| 18 Column 0 5 10 0 00 | |
| 19 Column 0 6 11 00 | |
| 20 Column 0 7 12 NULL 00 | |
| 21 Column 0 8 13 NULL 00 | |
| 22 Column 1 3 15 00 | |
| 23 String8 0 16 0 00 | |
| 24 Concat 16 15 3 00 | |
| 25 Column 1 4 16 00 | |
| 26 Concat 16 3 14 00 | |
| 27 ResultRow 5 10 0 00 | |
| 28 IfZero 1 32 -1 00 | |
| 29 IfPos 4 32 0 00 | |
| 30 NullRow 1 0 0 00 | |
| 31 Goto 0 12 0 00 | |
| 32 Close 0 0 0 00 | |
| 33 Close 1 0 0 00 | |
| 34 Halt 0 0 0 00 | |
| 35 Transaction 0 0 0 00 | |
| 36 VerifyCookie 0 56 0 00 | |
| 37 TableLock 0 10 0 documents 00 | |
| 38 TableLock 0 2 0 users 00 | |
| 39 Goto 0 4 0 00 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sele order from deta | |
| ---- ------------- ---- ---- | |
| 0 0 0 SEARCH TABLE documents AS CommentDocument USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) | |
| 0 1 1 SEARCH TABLE users AS User USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) | |
| addr opcode p1 p2 p3 p4 p5 comment | |
| ---- ------------- ---- ---- ---- ------------- -- ------------- | |
| 0 Trace 0 0 0 00 | |
| 1 Integer 1 1 0 00 | |
| 2 Integer 5 2 0 00 | |
| 3 Goto 0 28 0 00 | |
| 4 OpenRead 0 10 0 3 00 | |
| 5 OpenRead 1 2 0 5 00 | |
| 6 MustBeInt 2 25 0 00 | |
| 7 NotExists 0 25 2 00 | |
| 8 Integer 0 4 0 00 | |
| 9 Column 0 1 3 00 | |
| 10 MustBeInt 3 22 0 00 | |
| 11 NotExists 1 22 3 00 | |
| 12 Integer 1 4 0 00 | |
| 13 Rowid 0 5 0 00 | |
| 14 Column 0 2 6 00 | |
| 15 Column 1 3 8 00 | |
| 16 String8 0 9 0 00 | |
| 17 Concat 9 8 3 00 | |
| 18 Column 1 4 9 00 | |
| 19 Concat 9 3 7 00 | |
| 20 ResultRow 5 3 0 00 | |
| 21 IfZero 1 25 -1 00 | |
| 22 IfPos 4 25 0 00 | |
| 23 NullRow 1 0 0 00 | |
| 24 Goto 0 12 0 00 | |
| 25 Close 0 0 0 00 | |
| 26 Close 1 0 0 00 | |
| 27 Halt 0 0 0 00 | |
| 28 Transaction 0 0 0 00 | |
| 29 VerifyCookie 0 56 0 00 | |
| 30 TableLock 0 10 0 documents 00 | |
| 31 TableLock 0 2 0 users 00 | |
| 32 Goto 0 4 0 00 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sele order from deta | |
| ---- ------------- ---- ---- | |
| 0 0 0 SCAN TABLE users AS CommentUser (~1000000 rows) | |
| 0 1 1 SEARCH TABLE documents AS CommentDocument USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) | |
| addr opcode p1 p2 p3 p4 p5 comment | |
| ---- ------------- ---- ---- ---- ------------- -- ------------- | |
| 0 Trace 0 0 0 00 | |
| 1 Integer 1 1 0 00 | |
| 2 Integer 5 2 0 00 | |
| 3 Goto 0 32 0 00 | |
| 4 OpenRead 0 2 0 5 00 | |
| 5 OpenRead 1 10 0 3 00 | |
| 6 Rewind 0 29 0 00 | |
| 7 Integer 0 3 0 00 | |
| 8 MustBeInt 2 25 0 00 | |
| 9 NotExists 1 25 2 00 | |
| 10 Column 1 1 5 00 | |
| 11 Rowid 0 6 0 00 | |
| 12 Ne 6 25 5 collseq(BINARY) 6b | |
| 13 Integer 1 3 0 00 | |
| 14 Rowid 1 6 0 00 | |
| 15 Ne 2 25 6 6c | |
| 16 Rowid 1 7 0 00 | |
| 17 Column 1 2 8 00 | |
| 18 Column 0 3 4 00 | |
| 19 String8 0 5 0 00 | |
| 20 Concat 5 4 6 00 | |
| 21 Column 0 4 5 00 | |
| 22 Concat 5 6 9 00 | |
| 23 ResultRow 7 3 0 00 | |
| 24 IfZero 1 29 -1 00 | |
| 25 IfPos 3 28 0 00 | |
| 26 NullRow 1 0 0 00 | |
| 27 Goto 0 13 0 00 | |
| 28 Next 0 7 0 01 | |
| 29 Close 0 0 0 00 | |
| 30 Close 1 0 0 00 | |
| 31 Halt 0 0 0 00 | |
| 32 Transaction 0 0 0 00 | |
| 33 VerifyCookie 0 56 0 00 | |
| 34 TableLock 0 2 0 users 00 | |
| 35 TableLock 0 10 0 documents 00 | |
| 36 Goto 0 4 0 00 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment