Re: [sqlite] Multiple indexes in SQLite, and selecting which to use

l work. However, you have given me an idea - maybe I could break it down to two queries. Use the INDEX BY on the big table to get a subset table, and do another SELECT on the subset. Thanks. Sholto (His Nerdship) > Is there any way the code can 'suggest' SQLite use a certain index? Pavel

Re: [sqlite] Multiple indexes in SQLite, and selecting which to use

imizer is selecting a suboptimal index to use, and > there is no way to specify which index to use? > > On Aug 15, 2009, at 1:08 PM, His Nerdship wrote: > >> >> Good day, >> We have a puzzling problem with a large (1GB+) database. >> Most of our queries are

[sqlite] Multiple indexes in SQLite, and selecting which to use

Good day, We have a puzzling problem with a large (1GB+) database. Most of our queries are based on 3 columns, say X, Y and Z. X is always the first in the index. However, sometimes the query involves a small range of Y and a larger range of Z, and sometimes the reverse. We first had an index

[sqlite] sqlite3_mprintf - C/C++ formatting 64-bit values?

Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for 64-bit integers? I have tried %Ld and %I64d, but it just guillotines the string at that point. I am using Borland C++ Builder v6. Thanks in advance. -- View this message in context:

Re: [sqlite] Any concept of row number in SQLite?

in the grid. I can then index into this array and do a SELECT based on that ROWID. Problem solved. Thanks a lot, guys. Sholto His Nerdship Pty Ltd Derrell Lipman wrote: > > On Thu, Feb 19, 2009 at 10:45 PM, His Nerdship > <slgdoug...@optusnet.com.au>wrote: > >> >> T

Re: [sqlite] Any concept of row number in SQLite?

> grid and rowid in the database... that way you aren't relying on the > rowids being set a certain way, nor relying on the rowids being > returned to your app in a particular order. > >-T > > On Thu, Feb 19, 2009 at 9:09 PM, His Nerdship > <slgdoug...@optusnet.com.au

Re: [sqlite] Any concept of row number in SQLite?

of them might have changed from the original in the database so I can't use them in a WHERE clause. At least I know now Thanks again P Kishor-3 wrote: > > On Thu, Feb 19, 2009 at 6:54 PM, His Nerdship > <slgdoug...@optusnet.com.au> wrote: >> >> Hi, >> I am conver

[sqlite] Any concept of row number in SQLite?

Hi, I am converting a program from Paradox (stop laughing, please) to SQLite. Paradox has a useful feature where you can specify the actual index of a row in the table. This is handy when the table is displayed in a grid and you want the record corresponding to a row in that grid - you can just