On 5/19/16, Ertan K???ko?lu <ertan.kucukoglu at 1nar.com.tr> wrote: > Hello, > > I wonder if there are any drawbacks/things to be aware of, etc. for tables > created "WITHOUT ROWID". I am considering using such tables in another > project.
Experiment. Run your application with WITHOUT ROWID and measure performance (where "performance" is defined by whatever is important to you) then remove the WITHOUT ROWID and run the same experiment. Decide which works best for you. All of the application code should work the same either way, so other than removing the "WITHOUT ROWID" text from the "CREATE TABLE" no other changes are required. -- D. Richard Hipp drh at sqlite.org
