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

Reply via email to