Krishna: i see what you mean. so instead of querying for two lists you
do a prefixed self-join. i quickly test my version that queries two
lists that actually works fine, but i don't have a big test case yet.
coz anything bigger than thousand rows slows down in the dev server
even for simple query anyway, and i haven't had time to try that on
the production server yet. i reall don't need sorting, so i'm happy as
long as i could get "some of the results" safely and quickly
after reading your approach i was thinking, that it shoudlnt make a
difference querying the same list twice or two lists once. recalling
the zig-zag search in the "building scalable apps" talk, since both
versions mentioned above have two equality filters, it seems the query
will perform the same 'zig-zag' search, just on different values.
thanks much!
On Apr 27, 5:16 pm, Krishna <shrikrishna.sh...@gmail.com> wrote:
> I'm interested in hearing thoughts on this as well.
>
> Herbert: I had a similar problem sometime ago and I solved it by using
> a single ListProperty with custom prefixes to distinguish between
> fields of different types. So in your example, I would have used a
> prefix "f.." to represent a friend and "l.." to represent a like. So
> you would filter Users by friendlikes (one list property instead of
> two separate ones) == "f..me" && "l..A".
>
> On Apr 26, 7:20 pm, Herbert <herber...@gmail.com> wrote:
>
> > Sorry, suddenly got a thought on it.
>
> > Can I do two equality check on both User.friends and User.likes ?
> > would that be cause an "exploding index?"
>
> > I.E. User.all().filter("friends =", me).filter("likes =", A).fetch(3)
>
> > thanks!
> > Herbert
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google App Engine" group.
> > To post to this group, send email to google-appeng...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > google-appengine+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/google-appengine?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To post to this group, send email to google-appeng...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com.
> For more options, visit this group
> athttp://groups.google.com/group/google-appengine?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
