Do you know the max number of relationships allowed in 1 attribute? Baz
On Tue, Jun 2, 2009 at 10:24 AM, <[email protected]> wrote: > > Yes, obviously when you get to that extreme (10,000 CFC instances) the > developer is going to have to get smart about designing and accessing > the datastore. Note that the CFQUERY and GoogleQuery syntax supports a > "range" clause. When you get up to 10,000 entries, it might start to > make more sense to query the datastore ("select from blogEntry where > category = '#categoryName#' range 1,100") rather than doing batch > reads based on keys. > > Vince > > On Jun 2, 1:06 pm, Baz <[email protected]> wrote: > > > > > > Instead, I store the Google keys for the blogEntry.cfc instances > > > within the blogCategory.cfc and read the blogEntry.cfc instances only > > > when needed. > > > > If you had 10,000 blog entries or more this will probably break the app > > because you would reach the attribute length limit (which I can't seem to > > find, what is the max attribute size?). In cases like this, when it comes > to > > OO db's, I think it is recommended to choose the smaller side of the > > relationship to store your data. So instead of storing all posts that a > > category is related too in the category object, you would store all > > categories a post is related to in the post object - there will only be a > > few categories per post. To retrieve all posts for a certain category > then, > > you would do: > > > > SELECT FROM Post WHERE Category = 'App Engine' > > > > Baz > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
