Hello! В сообщении от Wednesday 18 February 2009 01:05:54 Paolo Pisati написал(а): > > 2. Add NOT NULL constraint to all fields. > > > > > > what does it buy me?
I think NULL values descrease B-tree indexes performance. P.S. You can split database for increase summary performance. For example 10 databases may be populated nearly 10x faster and attached as needed. Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users