because of reasons I have not been able to control I have had to strip all shared embedded objects from my object model instead opting for the reference id option. The problem is that I have about 60 types. There is one 'master' type called Product and everything else is in some way related to it, by fully embedded or reference ids.

Because my data for each Product is spread across so many objects I'm now being forced to do loads and loads of cfa_contentObjectGet's per page. On a page where I used to have only one trip to the database I now have to do about 10 and this only provides about 7 summary pieces of info about the Product.

Also since its taking 10-ish (possibly more for larger Products) trips to the database for each product summary I'm concerned that if a search returns 20 products and this summary info is used as a search result (which it is going to be) then I'm up for 200 trips to the database!! I'm I hearing alarm bells?

Admittedly these objects are very large but I'm thinking that 10 quick trips per product must surely be a lot slower than 1 large-ish one.

I've thought of duplicating the properties that I need to display within the product object as well as a reference id so that if I only need basic info then I don't need all DB trips. This of course causes issues when objects are getting updated later on. eg. I'll have to keep the properties of my Product in synch with the object that's reference id is also part of that product. If someone updates one of the referenced objects how do I then synchronise that update with all the 'simplifyed' versions of it I have in my Product's?

Hmm this is all hurting my brain a bit!

Can anyone suggest any resolution to my problem? Are there any design/coding changes I can make to speed things up a bit? Any help on this will be greatly appreciated.

Thanks for your help as always, Vaughan

p.s. hope you're all having a great festive season

~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.