Hi, Von: David Canterbrie
> I've been tasked with trying to understand how much of a performance hit one > would get if one had to scan a table in its entirety versus reading the same > data stored as a new-line (or some sort like that) from a file. > > The hypothesis I suppose we're trying to understand is that reading > sequentially from SQLite (without indices) should be comparable to reading > from a file that has the same data +/- 1-2% > > My first question is that does sound reasonable, and has someone ever done > such a test? I guess this highly depends on your data format and parser code. The author of http://sebastianraschka.com/Articles/sqlite3_database.html#results claims a factor ~20 speed advantage for SQLite. Best regards Markus Schaber CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH Inspiring Automation Solutions 3S-Smart Software Solutions GmbH Dipl.-Inf. Markus Schaber | Product Development Core Technology Memminger Str. 151 | 87439 Kempten | Germany Tel. +49-831-54031-979 | Fax +49-831-54031-50 E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: http://store.codesys.com CODESYS forum: http://forum.codesys.com Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade register: Kempten HRB 6186 | Tax ID No.: DE 167014915 This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users