Colin, On a very busy FarCry site our server admin ran a utility to monitor sql requests and automatically suggest/set indexes. this was some time go so cannot remember what indexes/improvements were made.
On other sites I usually start by adding indexes to the nested_tree_objects, recategories, refcontainers, refobjects - these have given very significant improvements - in one case just adding these indexes immediately dropped page load times from 5+ seconds to sub-second timings. Chris. On Dec 10, 8:53 am, Colin Jones <[email protected]> wrote: > On Nov 19, 10:19 am, Colin Jones <[email protected]> wrote: > > > I notice several posts about the lack of default indexing/optimisation > > in an out of the box installation, and also noted the following docs > > entries: > > >http://docs.farcrycms.org/display/FCDEV30/Database+Indexing+Strategie... > > > Both those documents reference FC3. So the questions are: > > > Do the same strategies apply to FC5? > > Are there any changes in the underlying structure that we need to take > > into account? > > Would the MYSQL script as provided work straight on an FC5 > > Installation? > > So may I take it from the silence that no one does any DB optimisation > then? -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
