Alexey Pechnikov wrote:
>
> I think you can to try
>
> 1. Replace date date, time time to single REAL field:
> date REAL NOT NULL DEFAULT (julianday('now'))
>
> And use as
> select date(date),time(date) from ...
>
>
ok, i'll try.
> 2. Add NOT NULL constraint to all fields.
>
>
what does it buy me?
> 3. Do reduce indices count - SQLite is very fast engine and indexes is not
> needed in most causes. Or
> you can build complex indices. For example:
>
right now i'm focusing on INSERT performance with 2 indexes only, would
be nice to have more...
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
