Hi Geoff, My DBA has done some working putting indexes on all the table he thinks should help, but things are still really slow.
He's also turned on the mysql option to log slow queries, so far nothing has been written to the log, so it is looking like maybe something with our CF setup? Can you think of any settings in CF would cause the poor performance? Cheers, Simon On Oct 18, 2:01 pm, modius <[EMAIL PROTECTED]> wrote: > 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/data... > > Regards, > > geoffhttp://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 -~----------~----~----~----~------~----~------~--~---
