You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi TonyGen
in mongodb table I have 50k data
in this 50k I have 20k data with some username(ravi1)
Cur = mongo:find (emaillist, {'$query', {'userName', UserName}, '$orderby', {'userName',1}}, {},0, 5),
when I do such find query, here I get 5 records but it takes same time finding all 20k records
but if
Hi TonyGen
in mongodb table I have 50k data
in this 50k I have 20k data with some username(ravi1)
Cur = mongo:find (emaillist, {'$query', {'userName', UserName}, '$orderby', {'userName',1}}, {},0, 5),
when I do such find query, here I get 5 records but it takes same time finding all 20k records
but if
Cur = mongo:find (emaillist, {'$query', {'userName', UserName}, '$orderby', {'userName',1}}, {},19,995, 5)
this also gives me 5 records but in no time
why first query takes more time to find 5 records
is there any other way so that I can get record faster in any case
The text was updated successfully, but these errors were encountered: