Hi all,
I want to know the depth of B+Tree in Sqlite, is there some way to
compute it?
suppose I konw the page size, table size, and entry nums. The B Tree depth
determine the
page number Sqlite has to get in a B Tree search, is right?
Thanks!
Hi all,
I have a question about alter table. for example, I create a table
person(ID integer primary key, name text, addr text),
Then I want to upgrade the table and add some columns, "alter table person
add age integer", I want to know the changed
table structure will have a big effect on the
Hi all,
I add some debug information in sqlite3.c, and test Sqlite cache metch
times, unmetch times and read() called times in Linux,
I found that page unmetch times in cache is bigger than read() called times.
Then I found in Btree.c getAndInitPage() function called
sqlite3PageLookup,
cache?
2. Cache was malloced in a transaction, and was freed at the end of a
transaction, is right?
3. Please intrduce the implement of cache mechanism in Sqlite.
Thanks very much!
Yoky
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
Hi all,
I create a table with 200 columns, then use sqlite3_prepare() and
sqlite3_step()to get a record by this: "select * from tbl where ID =.. ".
Test in my
embedded system,The total time is about 65ms,it is too long for the
performance
requirement, I found sqlite3_prepare() time is about
Hi all,
I create a table with 200 columns, then use sqlite3_prepare() and
sqlite3_step()
to get a record by this: "select * from tbl where ID =.. ". Test in my
embedded system
The total time is about 65ms,it is too long for the performance
requirement, I found
A parameter represents a literal. You can't bind a column name. After
binding, your query is equivalent to
select 'ID','age','name' from tbl1 where ID=1;
> The return value of sqlite3_step(stat) was SQLITE_ROW, but the
> values I got were 0,
> why?
Because the value of the column is a
some other ways to reduce the time of parse SQL
statement.
Are therer some good advices?
Thanks very much!
yoky
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
);
binding a blob and specifying a length of *two* and still can not select
the record I want by " select * from tbl1 where name ='aa' ",
I think maybe I should use: sqlite3_bind_text( ),
because this column type is a string. I will try last week!
yoky
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
te3_prepare(db, "select * from tbl1 where name like 'aa'
", -1, , 0);sqlite3_step(stat);
I can get the record.
Why? and How can I select record by "=" condition to a string?
Thanks!
yoky
___
sqlite-
Hi all,
I create a table with 250 columns and this table has 3 records, I
want to select the records from the table which satisfy certain conditions.
the SQL statement like this:
select * from tablename where (conditions);
Then use sqlite3_get_table() function to get the
lite3_exec() in 63534
line it works normally.
Thanks
yoky
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
12 matches
Mail list logo