Hi Tomasz, i tried with index on dishTypeId, also follow this link http://developer.db4o.com/Documentation/Reference/db4o-7.12/java/reference/html/reference/tuning/native_query_optimization/optimization_at_query_execution_time.html but did not get, so finally i moved for SODA query, that give me better performance.
-- but again my question is, if we have native query with bad performance then what's use? or may be something i am doing wrong? Regards Imran ali On May 6, 4:06 pm, Tomasz Adamski <[email protected]> wrote: > I think that creating an index on dishTypeId will drastically reduce query > time. > > In db4o 8.0 and above it will probably look something like this: > (while creating configuration for ObjectContainer) > > EmbeddedConfiguration embeddedConfiguration = > Db4oEmbedded.newConfiguration(); > embeddedConfiguration.common().objectClass(Recipe.class).objectField("dishTypeId").indexed(true); > > In older versions of db4o it looks very similar -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
