Hi Geoff, 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 ?
Regards Justin On Oct 16, 5:40 pm, modius <[EMAIL PROTECTED]> wrote: > On Oct 14, 7:24 pm, raZorTT <[EMAIL PROTECTED]> wrote: > > > Are other people that are using FC 5.0.2 having issues with the speed > > the site tree loads? > > > Mine takes minutes to load a branch when you expand it? There are only > > 5 children as well which is what confuses me. > > Well its a bit of a worry to hear you have minute loads for the site > tree. This is something that loads in seconds on my installations... > and I run a lot -- most very much larger than 5 children. > > The tree in 5.0 is slower initially (compared to 4.x), as we do a lot > of caching in the new security model. However, trying the same thing > in the tree a second time that session should be very quick. > > You may need to optimise your database schema. Make sure you have > primary keys and indexes set for the objectids, and so on. FarCry > does not provide an optimised schema by default and addressing this > may improve your performance. > > -- 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 -~----------~----~----~----~------~----~------~--~---
