"Ron Arts" <r...@arts-betel.org> schrieb im
Newsbeitrag news:4ad19195.2060...@arts-betel.org...
> I tried it, and indeed, this speeds up inserts tremendously as well,
> but in fact I'm not at all concernced about insert speed, but much more
about
> select speed. I use the following queries:
>
> CREATE TABLE company(id INTEGER PRIMARY KEY ASC, name)
Not sure, if an explicit "text-storage-class-hint" for your name
column will help to speed things up a bit more, but try:
CREATE TABLE company(id INTEGER PRIMARY KEY, name TEXT)
> Then I insert 500000 records like this:
>
> INSERT INTO company (id, name) VALUES ('1', 'Company name number 1')
You should prepare the statement like this:
INSERT INTO company (id, name) VALUES (?, ?)
And then treat the (now RowID-mapped) Integer ID as an
Integer, not as a String.
Just use the correctly "typed" binding-calls.
And then wrap the Insert-Loop within a transaction.
> But I'm still looking to speed up selects.
With regards to Selects (searching for random "single IDs"), you
probably already reached the maximum (in case you've not done
any mistakes with the Type-Binding).
Olaf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
