Corey Nelson <[EMAIL PROTECTED]> wrote: > It didn't take me long to get some test data into an SQLite3 database > file. But there's a problem, the database file is almost three times > bigger than storing the information in text files the way I had > planned.
Well, you can't get something for nothing. That additional space (occupied by an index) gives you the ability to quickly search through the database. > CREATE TABLE StockName (date TEXT UNIQUE ON CONFLICT REPLACE, price > REAL); If you don't want your table indexed, remove UNIQUE and ON CONFLICT clauses. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
