On Oct 17, 10:04 pm, jp <[EMAIL PROTECTED]> wrote: > I'd like to know what you recommend to improve performance. I've had a > look through the tables and most seem to have a primary key index on > the object_id wherever it appears. I've noticed there are no indexes > on tables such as dmnavigation_aobjectids where the object id's are > located inside table data. Is that what you are referring to with the > optimising ? I guess if database storage is not a problem as with most > smaller sites then indexes such as these have small overheads. What do > you suggest ?
Database optimisation is always a little bit tricky to automate :) Generally we try and look for anything that constitutes a primary join in the system. The relationships between primary content type tables and their array properties is quite important to index. Also lookups on refObjects, as this is constantly hit to determine the typename of content items. We use to have a good document on this back in the days of FarCry 3.0. I suspect its still pretty relevant with the current schema: http://www.daemon.com.au/go/services/training/tips-andamp-tricks/database-indexing-strategies-for-farcry Regards, geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to farcry-dev@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
