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, synthetic primary keys and heavy INSERT load by concurrent users, as it reduces lock contention. As you usually do not have many issues with too much concurrent write access in SQLite (or you might have picked the wrong tool for the job) and lock contention, the downside of pre-sorted loading is not an issue there. If you do pre-sort you might get blindingly fast range scans (at least until you get hit by disc fragmentation again). Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
