> I'm working on my first major site using farcry - I've done a few > fairly minor sites over the last few years - but nothing in depth. > Here is a question for the farcry gurus: > > FourQ handles all the db goodness in farcry - but does it handle the > creation of indexes at all?
Unfortunately no it doesn't. If not is this something that is typically performed by hand once a new > site is created? At the minute it is. I have been looking at creating a script that would create all the core indexes for MySQL versions of the database, but as with all these things other priorities have got in the way. For example there would be definite performance > advantages to having the ObjectID always indexed and no major drawback. It can only make it quicker for your database to retrieve records by one of the key identifiers. Any thoughts on this? There is an entry in the wiki on indexing strategies that should be of some assistance. http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Database+Indexing+Strategies+for+FarCry Regards Stephen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
