Debian Codegraph @

www/np1queryprob.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Many Small Queries Are Efficient In SQLite</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <div class=fancy>
119 <div class=nosearch>
120 <div class="fancy_title">
121 Many Small Queries Are Efficient In SQLite
122 </div>
123 </div>
124
125
126
127
128
129 <h1 id="executive_summary"><span>1. </span>Executive Summary</h1>
130
131 <ul>
132 <li><p>
133 200 SQL statements per webpage is excessive for client/server database
134 engines like MySQL, PostgreSQL, or SQL Server.
135
136 </p></li><li><p>
137 But with SQLite, 200 or more SQL statement per webpage is not a problem.
138
139 </p></li><li><p>
140 SQLite can also do large and complex queries efficiently, just like
141 client/server databases. But SQLite can do many smaller queries
142 efficiently too. Application developers can use whichever technique
143 works best for the task at hand.
144
145 </p></li></ul>
146
147 <h1 id="the_perceived_problem"><span>2. </span>The Perceived Problem</h1>
148
149 <p>
150 The <a href="whentouse.html#website">Appropriate Uses For SQLite</a> page says that
151 dynamic pages on the SQLite website typically do about 200 SQL
152 statements each.
153 This has provoked criticism from readers. Examples:
154
155 </p><ul>
156 <li><p>
157 <i>"200 SQL statements is a ridiculously high number for a single page"</i>
158 </p></li><li><p>
159 <i>"For most sites, 200 queries is way, way, way too much."</i>
160 </p></li><li><p>
161 <i>"&#91;This is&#93; bad design"</i>
162 </p></li></ul>
163
164 <p>
165 Such criticism would be well-founded for a traditional client/server
166 database engine, such as MySQL, PostgreSQL, or SQL Server. In
167 a client/server database, each SQL statement requires a message
168 round-trip from the application to the database server and back to
169 the application. Doing over 200 round-trip messages, sequentially,
170 can be a serious performance drag. This is sometimes called the
171 "N+1 Query Problem" or the "N+1 Select Problem" and it is an anti-pattern.
172
173 </p><h1 id="n_1_queries_are_not_a_problem_with_sqlite"><span>3. </span>N+1 Queries Are Not A Problem With SQLite</h1>
174
175 <p>
176 SQLite is <u>not</u> client/server, however. The SQLite database runs
177 in the same process address space as the application. Queries do not
178 involve message round-trips, only a function call. The latency
179 of a single SQL query is far less in SQLite. Hence, using a large number
180 of queries with SQLite is not the problem.
181
182 </p><h1 id="the_need_for_over_200_sql_statements_per_webpage"><span>4. </span>The Need For Over 200 SQL Statements Per Webpage</h1>
183
184 <p>
185 The dynamic webpages on the SQLite website are mostly generated by
186 the <a href="https://www.fossil-scm.org/">Fossil version control system</a>.
187 A typical dynamic
188 page would be a timeline such as <a href="https://sqlite.org/src/timeline">https://sqlite.org/src/timeline</a>.
189 A log of all SQL used by the timeline is shown below.
190
191 </p><p>
192 The first group of queries in the log are extracting display options
193 from the "config" and "global_config" tables of the Fossil database.
194 Then there is a single complex query that extracts a list of all elements
195 to be displayed on the timeline.
196 This "timeline" query demonstrates that SQLite can easily process complex
197 relational database queries involving multiple tables, subqueries, and
198 complex WHERE clause constraints, and it can make effective use of indexes
199 to solve the queries with minimal disk I/O.
200
201 </p><p>
202 Following the single big "timeline" query,
203 there are additional queries for each timeline element.
204 Fossil is using the "N+1 Query" pattern rather than trying
205 to grab all the information in as few queries as possible.
206 But that is ok because there is no unnecessary IPC overhead.
207 At the bottom of
208 each timeline page, Fossil shows approximately how long it took to generate
209 the page. For a 50-entry timeline, the latency is usually less than
210 25 milliseconds. Profiling shows that few of those milliseconds
211 were spent inside the database engine.
212
213 </p><p>
214 Using the N+1 Query pattern in Fossil does not harm the application.
215 But the N+1 Query pattern does have benefits. For one, the
216 section of the code that creates the timeline query can be
217 completely separate from the section that prepares each timeline
218 entry for display.
219 This provides a separation of responsibility that helps keep the code
220 simple and easy to maintain. Secondly, the information
221 needed for display, and the queries needed to extract that information,
222 vary according to what type of objects are to be shown. Check-ins need one
223 set of queries. Tickets need another set of queries. Wiki pages need a
224 different query. And so forth. By implementing these queries on-demand
225 and in the part of the code dealing with the various entities, there is
226 further separation of responsibility and simplification of the overall
227 code base.
228
229 </p><p>
230 So, SQLite is able to do one or two large and complex queries, or it can
231 do many smaller and simpler queries. Both are efficient. An application
232 can use either or both techniques, depending on what works best for the
233 situation at hand.
234
235 </p><p>
236 The following is a log of all SQL used to generate one particular
237 timeline (captured on 2016-09-16):
238
239 </p><div class="codeblock"><pre>-- sqlite3_open: /home/drh/sqlite/sqlite/.fslckout
240 PRAGMA foreign_keys=OFF;
241 SELECT sql FROM localdb.sqlite_schema WHERE name=='vfile';
242 -- sqlite3_open: /home/drh/.fossil
243 PRAGMA foreign_keys=OFF;
244 SELECT value FROM vvar WHERE name='repository';
245 ATTACH DATABASE '/home/drh/www/repos/sqlite.fossil' AS 'repository' KEY '';
246 SELECT value FROM config WHERE name='allow-symlinks';
247 SELECT value FROM global_config WHERE name='allow-symlinks';
248 SELECT value FROM config WHERE name='aux-schema';
249 SELECT 1 FROM config WHERE name='baseurl:http://';
250 SELECT value FROM config WHERE name='ip-prefix-terms';
251 SELECT value FROM global_config WHERE name='ip-prefix-terms';
252 SELECT value FROM config WHERE name='localauth';
253 SELECT value FROM vvar WHERE name='default-user';
254 SELECT uid FROM user WHERE cap LIKE '%s%';
255 SELECT login FROM user WHERE uid=1;
256 SELECT cap FROM user WHERE login = 'nobody';
257 SELECT cap FROM user WHERE login = 'anonymous';
258 SELECT value FROM config WHERE name='public-pages';
259 SELECT value FROM global_config WHERE name='public-pages';
260 SELECT value FROM config WHERE name='header';
261 SELECT value FROM config WHERE name='project-name';
262 SELECT value FROM config WHERE name='th1-setup';
263 SELECT value FROM global_config WHERE name='th1-setup';
264 SELECT value FROM config WHERE name='redirect-to-https';
265 SELECT value FROM global_config WHERE name='redirect-to-https';
266 SELECT value FROM config WHERE name='index-page';
267 SELECT mtime FROM config WHERE name='css';
268 SELECT mtime FROM config WHERE name='logo-image';
269 SELECT mtime FROM config WHERE name='background-image';
270 CREATE TEMP TABLE IF NOT EXISTS timeline(
271 rid INTEGER PRIMARY KEY,
272 uuid TEXT,
273 timestamp TEXT,
274 comment TEXT,
275 user TEXT,
276 isleaf BOOLEAN,
277 bgcolor TEXT,
278 etype TEXT,
279 taglist TEXT,
280 tagid INTEGER,
281 short TEXT,
282 sortby REAL
283 )
284 ;
285 INSERT OR IGNORE INTO timeline SELECT
286 blob.rid AS blobRid,
287 uuid AS uuid,
288 datetime(event.mtime,toLocal()) AS timestamp,
289 coalesce(ecomment, comment) AS comment,
290 coalesce(euser, user) AS user,
291 blob.rid IN leaf AS leaf,
292 bgcolor AS bgColor,
293 event.type AS eventType,
294 (SELECT group_concat(substr(tagname,5), ', ') FROM tag, tagxref
295 WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid
296 AND tagxref.rid=blob.rid AND tagxref.tagtype&gt;0) AS tags,
297 tagid AS tagid,
298 brief AS brief,
299 event.mtime AS mtime
300 FROM event CROSS JOIN blob
301 WHERE blob.rid=event.objid
302 AND NOT EXISTS(SELECT 1 FROM tagxref WHERE tagid=5 AND tagtype&gt;0 AND rid=blob.rid)
303 ORDER BY event.mtime DESC LIMIT 50;
304 -- SELECT value FROM config WHERE name='timeline-utc';
305 SELECT count(*) FROM timeline WHERE etype!='div';
306 SELECT min(timestamp) FROM timeline;
307 SELECT julianday('2016-09-15 14:54:51',fromLocal());
308 SELECT EXISTS (SELECT 1 FROM event CROSS JOIN blob WHERE blob.rid=event.objid AND mtime&lt;=2457647.121412037);
309 SELECT max(timestamp) FROM timeline;
310 SELECT julianday('2016-09-24 17:42:43',fromLocal());
311 SELECT EXISTS (SELECT 1 FROM event CROSS JOIN blob WHERE blob.rid=event.objid AND mtime&gt;=2457656.238009259);
312 SELECT value FROM config WHERE name='search-ci';
313 SELECT value FROM vvar WHERE name='checkout';
314 SELECT value FROM config WHERE name='timeline-max-comment';
315 SELECT value FROM global_config WHERE name='timeline-max-comment';
316 SELECT value FROM config WHERE name='timeline-date-format';
317 SELECT value FROM config WHERE name='timeline-truncate-at-blank';
318 SELECT value FROM global_config WHERE name='timeline-truncate-at-blank';
319 SELECT * FROM timeline ORDER BY sortby DESC;
320 SELECT value FROM config WHERE name='hash-digits';
321 SELECT value FROM global_config WHERE name='hash-digits';
322 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68028;
323 SELECT pid FROM plink WHERE cid=68028 AND pid NOT IN phantom ORDER BY isprim DESC;
324 SELECT 1 FROM tagxref WHERE rid=68028 AND tagid=9 AND tagtype&gt;0;
325 SELECT value FROM config WHERE name='timeline-block-markup';
326 SELECT value FROM config WHERE name='timeline-plaintext';
327 SELECT value FROM config WHERE name='wiki-use-html';
328 SELECT value FROM global_config WHERE name='wiki-use-html';
329 SELECT 1 FROM private WHERE rid=68028;
330 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68026;
331 SELECT pid FROM plink WHERE cid=68026 AND pid NOT IN phantom ORDER BY isprim DESC;
332 SELECT 1 FROM private WHERE rid=68026;
333 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68024;
334 SELECT pid FROM plink WHERE cid=68024 AND pid NOT IN phantom ORDER BY isprim DESC;
335 SELECT 1 FROM private WHERE rid=68024;
336 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68018;
337 SELECT pid FROM plink WHERE cid=68018 AND pid NOT IN phantom ORDER BY isprim DESC;
338 SELECT 1 FROM private WHERE rid=68018;
339 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68012;
340 SELECT pid FROM plink WHERE cid=68012 AND pid NOT IN phantom ORDER BY isprim DESC;
341 SELECT 1 FROM private WHERE rid=68012;
342 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68011;
343 SELECT value FROM config WHERE name='details';
344 SELECT pid FROM plink WHERE cid=68011 AND pid NOT IN phantom ORDER BY isprim DESC;
345 SELECT 1 FROM tagxref WHERE rid=68011 AND tagid=9 AND tagtype&gt;0;
346 SELECT 1 FROM private WHERE rid=68011;
347 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68008;
348 SELECT pid FROM plink WHERE cid=68008 AND pid NOT IN phantom ORDER BY isprim DESC;
349 SELECT 1 FROM private WHERE rid=68008;
350 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68006;
351 SELECT pid FROM plink WHERE cid=68006 AND pid NOT IN phantom ORDER BY isprim DESC;
352 SELECT 1 FROM private WHERE rid=68006;
353 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=68000;
354 SELECT pid FROM plink WHERE cid=68000 AND pid NOT IN phantom ORDER BY isprim DESC;
355 SELECT 1 FROM private WHERE rid=68000;
356 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67997;
357 SELECT pid FROM plink WHERE cid=67997 AND pid NOT IN phantom ORDER BY isprim DESC;
358 SELECT 1 FROM private WHERE rid=67997;
359 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67992;
360 SELECT pid FROM plink WHERE cid=67992 AND pid NOT IN phantom ORDER BY isprim DESC;
361 SELECT 1 FROM private WHERE rid=67992;
362 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67990;
363 SELECT pid FROM plink WHERE cid=67990 AND pid NOT IN phantom ORDER BY isprim DESC;
364 SELECT 1 FROM private WHERE rid=67990;
365 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67989;
366 SELECT pid FROM plink WHERE cid=67989 AND pid NOT IN phantom ORDER BY isprim DESC;
367 SELECT 1 FROM private WHERE rid=67989;
368 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67984;
369 SELECT pid FROM plink WHERE cid=67984 AND pid NOT IN phantom ORDER BY isprim DESC;
370 SELECT 1 FROM private WHERE rid=67984;
371 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67983;
372 SELECT pid FROM plink WHERE cid=67983 AND pid NOT IN phantom ORDER BY isprim DESC;
373 SELECT 1 FROM private WHERE rid=67983;
374 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67979;
375 SELECT pid FROM plink WHERE cid=67979 AND pid NOT IN phantom ORDER BY isprim DESC;
376 SELECT 1 FROM private WHERE rid=67979;
377 SELECT value FROM config WHERE name='ticket-closed-expr';
378 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='1ec41379c9c1e400' AND tkt_uuid&lt;'1ec41379c9c1e401';
379 SELECT 1 FROM private WHERE rid=67980;
380 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67977;
381 SELECT pid FROM plink WHERE cid=67977 AND pid NOT IN phantom ORDER BY isprim DESC;
382 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='1ec41379c9c1e400' AND tkt_uuid&lt;'1ec41379c9c1e401';
383 SELECT 1 FROM private WHERE rid=67977;
384 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='1ec41379c9c1e400' AND tkt_uuid&lt;'1ec41379c9c1e401';
385 SELECT 1 FROM private WHERE rid=67974;
386 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67971;
387 SELECT pid FROM plink WHERE cid=67971 AND pid NOT IN phantom ORDER BY isprim DESC;
388 SELECT 1 FROM private WHERE rid=67971;
389 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67972;
390 SELECT pid FROM plink WHERE cid=67972 AND pid NOT IN phantom ORDER BY isprim DESC;
391 SELECT 1 FROM private WHERE rid=67972;
392 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67969;
393 SELECT pid FROM plink WHERE cid=67969 AND pid NOT IN phantom ORDER BY isprim DESC;
394 SELECT 1 FROM private WHERE rid=67969;
395 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67966;
396 SELECT pid FROM plink WHERE cid=67966 AND pid NOT IN phantom ORDER BY isprim DESC;
397 SELECT 1 FROM private WHERE rid=67966;
398 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67962;
399 SELECT pid FROM plink WHERE cid=67962 AND pid NOT IN phantom ORDER BY isprim DESC;
400 SELECT 1 FROM private WHERE rid=67962;
401 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67960;
402 SELECT pid FROM plink WHERE cid=67960 AND pid NOT IN phantom ORDER BY isprim DESC;
403 SELECT 1 FROM private WHERE rid=67960;
404 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67957;
405 SELECT pid FROM plink WHERE cid=67957 AND pid NOT IN phantom ORDER BY isprim DESC;
406 SELECT 1 FROM private WHERE rid=67957;
407 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67955;
408 SELECT pid FROM plink WHERE cid=67955 AND pid NOT IN phantom ORDER BY isprim DESC;
409 SELECT 1 FROM private WHERE rid=67955;
410 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67953;
411 SELECT pid FROM plink WHERE cid=67953 AND pid NOT IN phantom ORDER BY isprim DESC;
412 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='5990a1bdb4a073' AND tkt_uuid&lt;'5990a1bdb4a074';
413 SELECT 1 FROM blob WHERE uuid&gt;='5990a1bdb4a073' AND uuid&lt;'5990a1bdb4a074';
414 SELECT 1 FROM private WHERE rid=67953;
415 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67941;
416 SELECT pid FROM plink WHERE cid=67941 AND pid NOT IN phantom ORDER BY isprim DESC;
417 SELECT 1 FROM private WHERE rid=67941;
418 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67940;
419 SELECT pid FROM plink WHERE cid=67940 AND pid NOT IN phantom ORDER BY isprim DESC;
420 SELECT 1 FROM private WHERE rid=67940;
421 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67938;
422 SELECT pid FROM plink WHERE cid=67938 AND pid NOT IN phantom ORDER BY isprim DESC;
423 SELECT 1 FROM private WHERE rid=67938;
424 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67935;
425 SELECT pid FROM plink WHERE cid=67935 AND pid NOT IN phantom ORDER BY isprim DESC;
426 SELECT 1 FROM private WHERE rid=67935;
427 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67934;
428 SELECT pid FROM plink WHERE cid=67934 AND pid NOT IN phantom ORDER BY isprim DESC;
429 SELECT 1 FROM private WHERE rid=67934;
430 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67932;
431 SELECT pid FROM plink WHERE cid=67932 AND pid NOT IN phantom ORDER BY isprim DESC;
432 SELECT 1 FROM private WHERE rid=67932;
433 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67930;
434 SELECT pid FROM plink WHERE cid=67930 AND pid NOT IN phantom ORDER BY isprim DESC;
435 SELECT 1 FROM private WHERE rid=67930;
436 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67928;
437 SELECT pid FROM plink WHERE cid=67928 AND pid NOT IN phantom ORDER BY isprim DESC;
438 SELECT 1 FROM tagxref WHERE rid=67928 AND tagid=9 AND tagtype&gt;0;
439 SELECT 1 FROM private WHERE rid=67928;
440 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='0eab1ac7591f511d' AND tkt_uuid&lt;'0eab1ac7591f511e';
441 SELECT 1 FROM private WHERE rid=67919;
442 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='01874d252ac44861' AND tkt_uuid&lt;'01874d252ac44862';
443 SELECT 1 FROM blob WHERE uuid&gt;='01874d252ac44861' AND uuid&lt;'01874d252ac44862';
444 SELECT 1 FROM private WHERE rid=67918;
445 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67916;
446 SELECT pid FROM plink WHERE cid=67916 AND pid NOT IN phantom ORDER BY isprim DESC;
447 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='0eab1ac759' AND tkt_uuid&lt;'0eab1ac75:';
448 SELECT 1 FROM private WHERE rid=67916;
449 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='a49bc0a8244feb08' AND tkt_uuid&lt;'a49bc0a8244feb09';
450 SELECT 1 FROM blob WHERE uuid&gt;='a49bc0a8244feb08' AND uuid&lt;'a49bc0a8244feb09';
451 SELECT 1 FROM private WHERE rid=67914;
452 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67913;
453 SELECT pid FROM plink WHERE cid=67913 AND pid NOT IN phantom ORDER BY isprim DESC;
454 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='0eab1ac7591f' AND tkt_uuid&lt;'0eab1ac7591g';
455 SELECT 1 FROM private WHERE rid=67913;
456 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67911;
457 SELECT pid FROM plink WHERE cid=67911 AND pid NOT IN phantom ORDER BY isprim DESC;
458 SELECT 1 FROM private WHERE rid=67911;
459 SELECT status='Closed' OR status='Fixed' FROM ticket WHERE tkt_uuid&gt;='0eab1ac7591f511d' AND tkt_uuid&lt;'0eab1ac7591f511e';
460 SELECT 1 FROM private WHERE rid=67909;
461 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67907;
462 SELECT pid FROM plink WHERE cid=67907 AND pid NOT IN phantom ORDER BY isprim DESC;
463 SELECT 1 FROM private WHERE rid=67907;
464 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67899;
465 SELECT pid FROM plink WHERE cid=67899 AND pid NOT IN phantom ORDER BY isprim DESC;
466 SELECT 1 FROM private WHERE rid=67899;
467 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67897;
468 SELECT pid FROM plink WHERE cid=67897 AND pid NOT IN phantom ORDER BY isprim DESC;
469 SELECT 1 FROM private WHERE rid=67897;
470 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67895;
471 SELECT pid FROM plink WHERE cid=67895 AND pid NOT IN phantom ORDER BY isprim DESC;
472 SELECT 1 FROM private WHERE rid=67895;
473 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67893;
474 SELECT pid FROM plink WHERE cid=67893 AND pid NOT IN phantom ORDER BY isprim DESC;
475 SELECT 1 FROM private WHERE rid=67893;
476 SELECT value FROM tagxref WHERE tagid=8 AND tagtype&gt;0 AND rid=67891;
477 SELECT pid FROM plink WHERE cid=67891 AND pid NOT IN phantom ORDER BY isprim DESC;
478 SELECT 1 FROM private WHERE rid=67891;
479 SELECT count(*) FROM plink
480 WHERE pid=67928 AND isprim
481 AND coalesce((SELECT value FROM tagxref
482 WHERE tagid=8 AND rid=plink.pid), 'trunk')
483 =coalesce((SELECT value FROM tagxref
484 WHERE tagid=8 AND rid=plink.cid), 'trunk')
485 ;
486 SELECT count(*) FROM plink
487 WHERE pid=68011 AND isprim
488 AND coalesce((SELECT value FROM tagxref
489 WHERE tagid=8 AND rid=plink.pid), 'trunk')
490 =coalesce((SELECT value FROM tagxref
491 WHERE tagid=8 AND rid=plink.cid), 'trunk')
492 ;
493 SELECT count(*) FROM plink
494 WHERE pid=68028 AND isprim
495 AND coalesce((SELECT value FROM tagxref
496 WHERE tagid=8 AND rid=plink.pid), 'trunk')
497 =coalesce((SELECT value FROM tagxref
498 WHERE tagid=8 AND rid=plink.cid), 'trunk')
499 ;
500 SELECT value FROM config WHERE name='show-version-diffs';
501 SELECT value FROM config WHERE name='adunit-omit-if-admin';
502 SELECT value FROM global_config WHERE name='adunit-omit-if-admin';
503 SELECT value FROM config WHERE name='adunit-omit-if-user';
504 SELECT value FROM global_config WHERE name='adunit-omit-if-user';
505 SELECT value FROM config WHERE name='adunit';
506 SELECT value FROM global_config WHERE name='adunit';
507 SELECT value FROM config WHERE name='auto-hyperlink-delay';
508 SELECT value FROM global_config WHERE name='auto-hyperlink-delay';
509 SELECT value FROM config WHERE name='footer';
510 PRAGMA database_list;
511 PRAGMA database_list;
512 PRAGMA localdb.freelist_count;
513 PRAGMA localdb.page_count;
514 </pre></div>
515 <p align="center"><small><i>This page was last updated on 2025-05-31 13:08:22Z </small></i></p>
516