bug-recutils
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[bug-recutils] [PATCH] torture: performance tests for simple recsel quer


From: Michał Masłowski
Subject: [bug-recutils] [PATCH] torture: performance tests for simple recsel queries finding a single record.
Date: Wed, 02 May 2012 20:12:05 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/23.3 (gnu/linux)

Hello,

This patch adds performance tests whose results could be improved by
indices and might resemble more common database queries.


2012-05-02  Michał Masłowski  <address@hidden>

        torture: performance tests for simple recsel queries finding a
        single record.
        * torture/utils/p-recsel.sh (recsel-200-records-single): New test.
        (recsel-500-records-single): Likewise.
        (recsel-1000-records-single): Likewise.
        (recsel-10000-records-single): Likewise.
        (recsel-20000-records-single): Likewise.
        (recsel-200-records-quick): Likewise.
        (recsel-500-records-quick): Likewise.
        (recsel-1000-records-quick): Likewise.
        (recsel-10000-records-quick): Likewise.
        (recsel-20000-records-quick): Likewise.


From 924302eb0edfa4956e002e174b440fd4d8f8cbff Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Micha=C5=82=20Mas=C5=82owski?= <address@hidden>
Date: Wed, 2 May 2012 19:51:20 +0200
Subject: [PATCH] torture: performance tests for simple recsel queries finding
 a single record.

---
 torture/utils/p-recsel.sh |   52 +++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 52 insertions(+), 0 deletions(-)

diff --git a/torture/utils/p-recsel.sh b/torture/utils/p-recsel.sh
index 38e07d9..4fee273 100755
--- a/torture/utils/p-recsel.sh
+++ b/torture/utils/p-recsel.sh
@@ -66,6 +66,58 @@ test_tool recsel-20000-records perf \
           "" \
           20000-records
 
+test_tool recsel-200-records-single perf \
+          recsel \
+          "-e 'field9 = \"value1999\"'" \
+          200-records
+
+test_tool recsel-500-records-single perf \
+          recsel \
+          "-e 'field9 = \"value1999\"'" \
+          500-records
+
+test_tool recsel-1000-records-single perf \
+          recsel \
+          "-e 'field9 = \"value1999\"'" \
+          1000-records
+
+test_tool recsel-10000-records-single perf \
+          recsel \
+          "-e 'field9 = \"value1999\"'" \
+          10000-records
+
+test_tool recsel-20000-records-single perf \
+          recsel \
+          "-e 'field9 = \"value1999\"'" \
+          20000-records
+
+test_tool recsel-200-records-quick perf \
+          recsel \
+          "-q value1999" \
+          200-records
+
+test_tool recsel-500-records-quick perf \
+          recsel \
+          "-q value1999" \
+          500-records
+
+test_tool recsel-1000-records-quick perf \
+          recsel \
+          "-q value1999" \
+          1000-records
+
+# Use bigger values to keep similar output size.
+
+test_tool recsel-10000-records-quick perf \
+          recsel \
+          "-q value19999" \
+          10000-records
+
+test_tool recsel-20000-records-quick perf \
+          recsel \
+          "-q value199999" \
+          20000-records
+
 test_tool recsel-200-records-sex-regexp perf \
           recsel \
           "-e 'field4 ~ \".*04.*\"'" \
-- 
1.7.5.4

Attachment: pgpAR8wpvBAZU.pgp
Description: PGP signature


reply via email to

[Prev in Thread] Current Thread [Next in Thread]