Re: [sqlite] Any advantage to pre-sorting data before loading and indexing it?

Stefan and Michael, Thank you very much for your feedback. Regards, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Any advantage to pre-sorting data before loading and indexing it?

pyt...@bdurham.com schrieb: > Is there any advantage to having data pre-sorted (in index order) > before loading it into SQLite and indexing it? Or does indexing > work best if the index values are randomly ordered at data load > time? Random order might help you with some multi-user databases,

Re: [sqlite] Any advantage to pre-sorting data before loading and indexing it?

On 17 Feb 2009, at 15:34, pyt...@bdurham.com wrote: > Is there any advantage to having data pre-sorted (in index order) > before loading it into SQLite and indexing it? Or does indexing > work best if the index values are randomly ordered at data load > time? From my own experience, there's a

[sqlite] Any advantage to pre-sorting data before loading and indexing it?

Is there any advantage to having data pre-sorted (in index order) before loading it into SQLite and indexing it? Or does indexing work best if the index values are randomly ordered at data load time? Thanks, Malcolm ___ sqlite-users mailing list