On Mon, Oct 11, 2010 at 12:33 AM, arny <arny...@googlemail.com> wrote: > Hi, > > I'm really confused about the AppEngine database index limits. > > My project is using 15 tokens to index some content. > I'm using the index then to self-join it up to 3 times. > Then my index looks like this: isOnline ▲ , searchIndex ▲ , > searchIndex ▲ , searchIndex ▲ , normalizedName ▲ > > isOnline = boolean > searchIndex = list (max 15 items) > normalizedName = string > > Now as soon I add another searchIndex or another property to the > indexes I get an error when AppEngine is trying to build the indexes. > > -- BUT -- > > Then again I'm looking at the > http://code.google.com/p/guestbook-example-appengine-full-text-search/ > example which was mentioned by Googles AppEngine Team. > This project is using 200 tokens to index! and self-joining it up to 5 > times! > > How is that possible and what I am doing wrong? > I need at least one more property to be added to the index.
Hi, you cannot use explicit indexes with self merge joins. Therefore your index building breaks (so called "exploding indexes" problem). You have to arrange your queries in a way that you take advantage of the self merge joins described in http://code.google.com/p/guestbook-example-appengine-full-text-search/ - but all additional sorting must take place in memory... Cheers, Raphael > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to google-appengine-j...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
