X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=ftsbench.git;a=blobdiff_plain;f=README;h=e1a28f020b67fe25520363c894e14c6f7d680e19;hp=ed1772e13a0d51884dd30358fc855f9f21788a00;hb=HEAD;hpb=34dc32fe558e25dfe4c7c80b94b126e597ebac2f diff --git a/README b/README index ed1772e..e1a28f0 100644 --- a/README +++ b/README @@ -1,9 +1,8 @@ Full-text search benchmark. -Before compilating, edit Makefile for RDBMS set and -paths to its. +Set RDBMS and paths in Makefile before compilation. -Init example: +Initialization example: ./ftsbench -i -n 10000 -f gin -b pgsql -d contrib_regression Benchmark example: @@ -19,7 +18,7 @@ MySQL prerequisite: tested on 5.0.24a ./configure --enable-thread-safe-client --with-pthread -SQL mode (output may be redirected into file ot to database): +SQL mode (output may be redirected to file or database): % ftsbench -S | psql postgres % ftsbench -i -n 10 -f gin -s 17 -d contrib_regression INSERT INTO fb_create (id, rdbms, f_gin, f_gist, f_func, rows, elapsed) VALUES (17, 'pgsql', 't', 'f', 'f', 10, 0.528075); @@ -27,9 +26,9 @@ INSERT INTO fb_create (id, rdbms, f_gin, f_gist, f_func, rows, elapsed) VALUES ( INSERT INTO fb_search (id, f_and, f_or, nclients, nqueries, nres, elapsed) VALUES (17, 't', 'f', 2, 2, 0, 0.063508); % ftsbench -c 2 -n 2 -f gin -s 17 -r -d contrib_regression INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.039024); -INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.009069); +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 1, 0.009069); INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.061368); -INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 0, 0.003654); +INSERT INTO fb_row (id, f_and, f_or, nclients, nres, elapsed) VALUES (17, 't', 'f', 2, 3, 0.003654);