Re: [appengine-java] Indexes - how to deal with them?

2011-12-14 Thread Ikai Lan (Google)
Every property creates 2 indexes, so if you don't want to incur write
operations, mark properties you will never query on (select from people
where age=26 - you need both an ASC and DESC index on the "age" property)
as unindexed.

Here's an old but good talk about how these indexes are used and why they
are needed:

http://www.youtube.com/watch?v=tx5gdoNpcZM

--
Ikai Lan
Developer Programs Engineer, Google App Engine
plus.ikailan.com | twitter.com/ikai



On Wed, Dec 14, 2011 at 1:09 AM, Paul  wrote:

> Hi,
>
> I am looking through my app and there are many index writes, way too
> many. How to handle them properly? I guess I should set unindexed to
> most properties, can I do it for whole entity and then just set
> "false" on fields that I want indexed? Will that work?
>
> @Extension(vendorName "datanucleus", key "gae.
> unindexed", value"true")
>
> Is there any way to see what is indexed and where do my index write
> operations come from? My other problem is that even when I am not
> doing any db operations, I have few hundred index write ops per day.
> The only thing that is happening is pingdom testing my login page,
> without doing anything. How can I track what is doing that operations?
>
> --
> 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-java@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-java@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.



[appengine-java] Indexes - how to deal with them?

2011-12-14 Thread Paul
Hi,

I am looking through my app and there are many index writes, way too
many. How to handle them properly? I guess I should set unindexed to
most properties, can I do it for whole entity and then just set
"false" on fields that I want indexed? Will that work?

@Extension(vendorName "datanucleus", key "gae.
unindexed", value"true")

Is there any way to see what is indexed and where do my index write
operations come from? My other problem is that even when I am not
doing any db operations, I have few hundred index write ops per day.
The only thing that is happening is pingdom testing my login page,
without doing anything. How can I track what is doing that operations?

-- 
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-java@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.