annotate .hgignore @ 2787:298408833ec2

memory (sqlite): optimizations indexes were missing on foreign keys for "message", "subject" and "thread" tables, seriously impacting performances. In addition to those indexes, two indexes have been added to speed ordering by timestamp on "history", and one on "files" table. history.rowid is not used anymore as there is an index on (profile_id, received_timestamp) which will speed up the query. Primary keys order has been changed to use automatic index in most common cases (filtering by profile_id then namespace).
author Goffi <goffi@goffi.org>
date Sat, 19 Jan 2019 22:49:32 +0100
parents f2cb99b196b1
children 9f599ccbea4e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
0208f9ac426a added .hgignore
Goffi <goffi@goffi.org>
parents:
diff changeset
1 syntax: glob
0208f9ac426a added .hgignore
Goffi <goffi@goffi.org>
parents:
diff changeset
2 *.pyc
140
e496134ed679 added .pyv & twistd.pid to .hgignore
Goffi <goffi@goffi.org>
parents: 4
diff changeset
3 *.pyv
3
0208f9ac426a added .hgignore
Goffi <goffi@goffi.org>
parents:
diff changeset
4 *.swp
0208f9ac426a added .hgignore
Goffi <goffi@goffi.org>
parents:
diff changeset
5 *.swo
0208f9ac426a added .hgignore
Goffi <goffi@goffi.org>
parents:
diff changeset
6 tags
4
3c1cefd41186 added sat executable
Goffi <goffi@goffi.org>
parents: 3
diff changeset
7 twistd.log
140
e496134ed679 added .pyv & twistd.pid to .hgignore
Goffi <goffi@goffi.org>
parents: 4
diff changeset
8 twistd.pid
269
78140bb2f0e3 updated .hgignore
Goffi <goffi@goffi.org>
parents: 140
diff changeset
9 bridge_constructor/generated
335
Goffi <goffi@goffi.org>
parents: 269
diff changeset
10 _trial_temp/
269
78140bb2f0e3 updated .hgignore
Goffi <goffi@goffi.org>
parents: 140
diff changeset
11 sat.egg-info
78140bb2f0e3 updated .hgignore
Goffi <goffi@goffi.org>
parents: 140
diff changeset
12 *.un~
78140bb2f0e3 updated .hgignore
Goffi <goffi@goffi.org>
parents: 140
diff changeset
13 dist
78140bb2f0e3 updated .hgignore
Goffi <goffi@goffi.org>
parents: 140
diff changeset
14 MANIFEST
474
e519f8f33cba misc: Add the build directory to the ignore file.
Emmanuel Gil Peyrot <linkmauve@linkmauve.fr>
parents: 335
diff changeset
15 build
598
af900f49df89 misc: add ctags_links to .hgignore
Goffi <goffi@goffi.org>
parents: 474
diff changeset
16 ctags_links/
1127
f2cb99b196b1 misc: added Session.vim to .hgignore
Goffi <goffi@goffi.org>
parents: 598
diff changeset
17 Session.vim