On Sat, 29 Jan 2011 15:07:47 -0800 (PST) Rael Bauer <rael_ba...@yahoo.com> wrote:
> It seemed strange that a simple "select * from table" that I was > doing was so slow. The table contained about 20 columns (fields) and > 300 rows. The select took about 1.5 seconds. (using SQLite Expert). > > So my questions: > Is this standard behaviour for sql databases? (that I have only found > out now). Is there actually some way to bypass this "problem" (e.g. > database setting..)? Is it generally advisable to separate out blob > fields into their own table to ensure fast select speeds? You should normalize your schema, 20 columns are too many columns. Also, consider to write the blob as file outside the database and put just the path in the database > > Thanks > Rael Bauer HTH _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
