scratchpad:random_magic_spells
Differences
This shows you the differences between two versions of the page.
scratchpad:random_magic_spells [2018/08/23 11:59] – bmagic | scratchpad:random_magic_spells [2022/02/10 13:34] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 228: | Line 228: | ||
netscape.security.PrivilegeManager.enablePrivilege(" | netscape.security.PrivilegeManager.enablePrivilege(" | ||
</ | </ | ||
+ | |||
+ | ====== Performance ====== | ||
+ | =====Preload Your database into RAM===== | ||
+ | Find your database' | ||
+ | < | ||
+ | psql -U evergreen -h localhost -d postgres -c " | ||
+ | </ | ||
+ | |||
+ | Then, as the root or postgres user, run the following commands | ||
+ | < | ||
+ | cd / | ||
+ | cat * > /dev/null | ||
+ | </ | ||
+ | |||
+ | Replace ${pgversion} with your PostgreSQL version number, ex. 9.5. Replace ${oid} with the number returned by the database query. | ||
====== Utility ====== | ====== Utility ====== | ||
Line 553: | Line 568: | ||
where | where | ||
clones.data=naming.data and | clones.data=naming.data and | ||
- | naming.folder in(select id from reporter.template_folder where owner=10497 and shared and share_with=1) and | + | naming.folder in(select id from reporter.template_folder where owner= |
naming.owner= | naming.owner= | ||
group by 1 | group by 1 |
scratchpad/random_magic_spells.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1