On Thu, 2 Jul 2009 11:02:44 -0400, "Shaun Seckman (Firaxis)"
<shaun.seck...@firaxis.com> wrote:
>Consider the following SQL Statement:
>
>
>
>create table foo(val1 integer, val2 integer, val3 integer);
>
>insert into foo values('1', '2', '3');
>
>
>When I call sqlite3_column_int(stmt, columnNum), must it convert the
>string to integer each time or will it perform that conversion on
>insertion?
No need to ask here. You can try that yourself:
SELECT typeof(val1),val1 FROM foo;
>Is it faster at retrieving the values as integers
>if I insert them as integers instead of strings?
In this case there is no difference.
In general SQLite performs at its best if you use integers
everywhere.
If you have the intention to use integers anyway, use them
and not some other type, if only for clear, consistent,
selfdocumenting code.
So, make that insert:
INSERT INTO foo VALUES (1, 2, 3);
>-Shaun
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
