On Nov 19, 9:19 pm, 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...http://docs.farcrycms.org/display/FCDEV30/Database+Indexing+Script > > Both those documents reference FC3. So the questions are: > > Do the same strategies apply to FC5?
By and large, yes. > Are there any changes in the underlying structure that we need to take > into account? If anything the schema has become more standard since 3.0 -- many things that were custom are now content types in their own right and so follow the same basic strategies that are outlined in the document you reference. > Would the MYSQL script as provided work straight on an FC5 > Installation? Probably. We optimise databases based on the application -- if only have a few hundred records then indexes can slow down the performance of your application or have little or no impact. For larger record sets they are critical. You want to make sure that anything ending in ID has an index. Any date property that you are referencing in a where clause -- for example, publishdate for news -- should be indexed. Primary key/Foreign Key relationships between array tables and their parent content type should be indexed. Things like MSSQL have great little tools that do all this for you by the way -- you just log the activity of your application for a few days, then apply the indexing wizard. It'll make a bunch of recommendations based on your actual usage patterns. Hope that helps, -- geoff http://www.daemon.com.au/ -- 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
