Re: [sqlite] Sqlite as a platform performance comparison tool
Max Vlasov wrote: > A thought came to compare two computers of different platforms (ie > i386 vs ARM) using uniform approach. We take two binaries of the same > sqlite version compiled with the best c compilers for both platforms > and compare the time spent for identical operations using memory based > databases (to exclulde I/O from measuring). > > Is such comparision correct? A benchmark measures nothing more than the time needed to execute that benchmark. A _good_ benchmark has performance characteristics that are similar to those of the code you actually intend to run and care about. Whether a particular benchmark works well for you is impossible to say without knowing what you want to measure. Words like "uniform approach" are meaningless in this context, but I should mention that I/O is part of the platform, and matters in most real-world applications. Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite as a platform performance comparison tool
Hi, A thought came to compare two computers of different platforms (ie i386 vs ARM) using uniform approach. We take two binaries of the same sqlite version compiled with the best c compilers for both platforms and compare the time spent for identical operations using memory based databases (to exclulde I/O from measuring). So, we could start with some comparatively large table loaded into :memory: database and the following operations is going to make joins/inserts etc probably as a single, semicolon delimited set of queries. The sets are identical for both platforms and is probably is best handled with a single sqlite3_exec Is such comparision correct? So maybe even for memory-based operation there is something that makes this comparision invalid? Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users