Thank you Simon! >Can you explain what SQLite calls you are using to do this ? Do you mean you >are using a CREATE INDEX command ?
Yes indeed. The command reads: "CREATE INDEX data_idx ON data (key ASC);" >Also, can you execute "PRAGMA journal_mode" on your database and tell us the >result ? The journal_mode is "delete". Kindest regards, Gao Student in Statistical Genetics, Baylor College of Medicine (the same Gao as from: gaow [at] bcm.edu / gaow [at] rice.edu) > > On 23 Jul 2012, at 10:24pm, "Wang, Gao" <wangow at gmail.com> wrote: >> I am having problems creating index for my database. >Can you explain what SQLite calls you are using to do this ? Do you mean you >are using a CREATE INDEX command ? >Also, can you execute "PRAGMA journal_mode" on your database and tell us the >result ? >Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users