Feature (or pull) request!

[Nicolas Garfinkiel]

Hey guys,

Is it possible to have something like QueryByKeyPrefix<T>(string keyPrefix)?

This is my case: I have lots and lots of entities that I just need to get as a list and I feel that it's a shame to have so many indexes that don't serve any purpose (and dunno if they can be an issue performance-wise).

I know there is StartsWith in DatabaseCommands, but it returns JsonDocuments and it would be nice to have the deserialized entity properly tracked and cached.

What do you think? Can you do it? Or would you like to have it pull-requested?

Cheers,

Nicolas.

[Oren Eini (Ayende Rahien)]

Take a look at build 93x, session.Advanced.LoadStartingWith()

[Nicolas Garfinkiel]

Great! Thanks for your reply!

On Friday, May 11, 2012 8:33:31 PM UTC-3, Oren Eini wrote:

Take a look at build 93x, session.Advanced.LoadStartingWith()

[Nicolas Garfinkiel]

Getting back on the subject... Is there any way to get the total records from the DB? Need it for paging purposes.

Cheers.

[Troy]

This should help:

 

http://ayende.com/blog/4680/ravendb-working-with-the-query-statistics

[Nicolas Garfinkiel]

Thanks Troy, but that would involve to hit an index.

What I'm looking for is to get the total records for the session.Advanced.LoadStartingWith()

Cheers.

On Tuesday, May 15, 2012 5:46:46 PM UTC-3, Troy wrote:

This should help:

 

http://ayende.com/blog/4680/ravendb-working-with-the-query-statistics

[Itamar Syn-Hershko]

What's the problem with hitting the index?

A total number of documents is available to you via the /stats endpoint, for any further drill down you'll have to query an index if all you want is the count

[Oren Eini (Ayende Rahien)]

No, we don't know that number for starts with, actually. Figuring it out could be costly in large instances, so we don't do this.