[sqlite] Getting row number in a sorted list.

Hi, I have a database with NameTable having name records in it, I need to get the row number of the first record in the sorted list of names for which the search name matches. Example, for below entries in NameTable Name 1. PTN 2. ABCD 3. CDE 4. PQRS 5. AXN

[sqlite] Getting row number in a sorted list.

To: General Discussion of SQLite Database Subject: Re: [sqlite] Getting row number in a sorted list. On Wed, Aug 19, 2015 at 7:40 AM, Simon Slavin wrote: > > On 19 Aug 2015, at 1:16pm, Anthrathodiyil, Sabeel (S.) < > santhrat at visteon.com> wrote: > > > Example, for be

[sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

Hi, I am facing issue with SQLite performance when having more records in the table and fetching from higher offsets, though I have proper index in place. Using SQLite version 3.7.10 running on ARM Cortex A5 processor. Here is my schema (relevant table and index) and query CREATE TABLE

Re: [sqlite] QUERY: Usage of malloc and free in SQLite

Hi Dan, Custom memory management APIs registered are being used by SQLite. We suspect SQLite, in certain cases is freeing allocated memory, not using the registered API to free. As part of our investigation, we are maintaining the starting address of the memory allocated and size allocated,

[sqlite] SQLIte crash in sqlite3_db_release_memory

Hi, I am facing a crash while invoking "sqlite3_db_release_memory" the crash is from pcache1RemoveFromHash. SQLite 3.7.10 is running on ARM A5 with Freescale MQX as OS. Stack trace is as below -- pcache1RemoveFromHash pcache1EnforceMaxPage pcache1Shrink