I am executing a query on a repository, to get all nodes of a specif type. There is around 10.000 records of that type and query lasts for 25 seconds.
Sql is someting like this : select id, userName, likesCount, talkingAboutCount from pageProvider order by likesCount asc when i remove "order by clause", it comes down to 17 seconds. isn't it too slow, though there is not where clause? and besides, can i add an index for a field, like db index, not search index to fasten queries whose "where clause" includes that field?
