Most individual attributes are indexed automatically unless you
specify otherwise (I believe the only exceptions are the equivalent's
of the python SDK's TextProperty and BlobProperty).  The indexing
scales fine; the only real issue with having unneeded indexes for the
properties of millions of entities is the space it takes to store
them.  There's a cost at write time as well, but the marginal cost of
updating indexes for any one entity is fairly small unless you have an
exploding index problem, which is only going to occur with composite
indexes anyway.

BTW, the indexes don't help you get "faster results for a query";
without an index you get no results at all.  Unlike most RMDBSes, you
can't choose to filter queries based on unidexed properties and just
live with the incredible slowness of scanning the whole table.  You
get fast queries or none at all.

On Aug 28, 4:52 am, Rahul Kumar <rahul.k...@gmail.com> wrote:
> Hi Tim
>
> But I am using this through java API. I have the Data & Ported it with &
> without index but I am getting index on all the attributes & dont know
> whether it will work or not on Million records to get faster result through
> query.
>
>
>
> On Fri, Aug 28, 2009 at 12:35 PM, Tim Hoffman <zutes...@gmail.com> wrote:
>
> > Hi
>
> > I found out earlier you can query what indexes exist, but you can't
> > create them through the api (even though the call exists) at least in
> > the the python sdk
>
> > Have a look at this thread
>
> >http://groups.google.com.au/group/google-appengine/browse_thread/thre...
>
> > Rgds
>
> > Tim
>
> > On Aug 27, 11:30 am, rahul kumar <rahul.k...@gmail.com> wrote:
> > > Hello Techies
>
> > > I want to create Indexes using Google' Datastore Api so that when I am
> > > saving my entities,I can be able to create & get Indexes also to make
> > > it easy for my application to search Data.
>
> > > How can I achieve this.
>
> > > Please help
>
> > > thanks
> > > Rahul Kumar
>
> --
> _ _ _ _ _ _ _ _ _ _
>
> Thanks & Regards
>
> Rahul Kumar
--~--~---------~--~----~------------~-------~--~----~
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-appengine@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to