[sqlite] Heap Memory usage in Sqlite

[Sreedhar.a]

Hi,
 
I am working with the database of 40k records.
My database table contains the metadata information of audio files.
 
When I searched for the first 50 records, the heap usage is small.
when I searched for the last 50 records, the heap usage is almost equal to
searching the entire database table.
 
Is it the same way the sqlite behaves? or I am doing anything wrong.
 
Thanks & Best Regards,
A.Sreedhar.