In addition,
- make a new index only on column1
- move the prepare before the loop to avoid reparsing the SELECT each time
- use sqlite3_bind_* and sqlite3_reset in the loop.
- move finalize after the loop.
- query the test table directly - not the temporary ttest table.
- don't SELECT * if you
Your keys are too large and have the same leading characters.
Since the first hundred characters are the same you waste a lot
of CPU time in comparisons.
Try to get your total key size down to a fraction of that size.
At least change your program to generate keys of this form
instead and it
Hi All,
Pls find the sample test below,
A) Using Sqlite 3.3.17,SuSE9 version,8GB Ram,4 CPU machine,
1) Compile the generate the test data program and generate the data
2) Import the data to DB
3) Compile the perf Data program and then generate perf result.
4) Result for 100,000 records it takes
Thank you very much Igor. This will do exactly what I need.
Igor Tandetnik wrote:
Lucas (a.k.a T-Bird or bsdfan3)
<[EMAIL PROTECTED]> wrote:
I am using SQLite in an application within a game where I have a table
of player nicknames and cumulative player scores (among other things).
How do I
Lucas (a.k.a T-Bird or bsdfan3)
<[EMAIL PROTECTED]> wrote:
I am using SQLite in an application within a game where I have a table
of player nicknames and cumulative player scores (among other things).
How do I figure out at what (numeric) one of these records would be at
if the table were
Hi RaghavendraK,
* RaghavendraK 70574 <[EMAIL PROTECTED]> [2007-06-25 08:45]:
> When the DB is opened in "in Memory mode",performance of query
> does not improve. For table which has 10 columns of type Text
> and each column having 128bytes data and having a total of
> 1 records.
that is
I am using SQLite in an application within a game where I have a table
of player nicknames and cumulative player scores (among other things).
How do I figure out at what (numeric) one of these records would be at
if the table were sorted, say, by the cumulative scores column? Or
should I
7 matches
Mail list logo