diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/datastore/perf_plugin_datastore.c | 2 | ||||
| -rw-r--r-- | src/datastore/selectrandom.sql | 9 |
2 files changed, 10 insertions, 1 deletions
diff --git a/src/datastore/perf_plugin_datastore.c b/src/datastore/perf_plugin_datastore.c index c5ef9841d8..7a8a0d4cf9 100644 --- a/src/datastore/perf_plugin_datastore.c +++ b/src/datastore/perf_plugin_datastore.c @@ -37,7 +37,7 @@ * those take too long to run them in the usual "make check" * sequence. Hence the value used for shipping is tiny. */ -#define MAX_SIZE 1024LL * 1024 * 32 +#define MAX_SIZE 1024LL * 1024 * 16 #define ITERATIONS 2 diff --git a/src/datastore/selectrandom.sql b/src/datastore/selectrandom.sql new file mode 100644 index 0000000000..82830a13a8 --- /dev/null +++ b/src/datastore/selectrandom.sql @@ -0,0 +1,9 @@ +select * +from (select random() as v from (values(1))) t1, + (select max(repl) as m from data) t2, + (select * from data + where repl=t2.m and + rnd>=t.v + order by rnd + limit 1) + |