Also
skip 10
limit 50
order by key DESC
in this query gives different results than
order by key DESC
skip 10
limit 50
on the same query, which was unexpected to me
On Friday, February 6, 2015 at 12:21:14 PM UTC, syshex wrote:
>
> Using a Query like so :
>
> select
> expand(rid)
> from index:Papers.publicationDate
> skip 10
> limit 50
> order by key DESC
>
> makes orientdb fire a warning :
>
> 2015-02-06 12:16:33:718 INFO {db=testdb} [TIP] Query 'select
> expand(rid) from index:Papers.publicationDate skip 10 limit 30 order by
> key DESC' returned a result set with more than 10000 records. Reduce it
> to improve performance and reduce RAM used [OProfiler]
>
> I'm failing to understand why it returns a result set with more than 10000
> records.
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
