diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2005-10-03 14:41:42 +0000 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2005-10-03 14:41:42 +0000 |
| commit | 8c73dfcc8b7801dcc6a46157ea5bd3aacedcea3f (patch) | |
| tree | 3c2c7359fccef79c8c7edd4896429e6f3773cdd5 /contrib/intarray/bench | |
| parent | a87174dca11aa84f485f4262766e53c5707d1b06 (diff) | |
Optimize benchmark query and update benchmark's results.
Diffstat (limited to 'contrib/intarray/bench')
| -rwxr-xr-x | contrib/intarray/bench/bench.pl | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/contrib/intarray/bench/bench.pl b/contrib/intarray/bench/bench.pl index 2e30956721c..66df02dfc11 100755 --- a/contrib/intarray/bench/bench.pl +++ b/contrib/intarray/bench/bench.pl @@ -42,7 +42,9 @@ if ( $opt{a} ) { push @where, "message.sections @ '{$opt{s}}'"; } else { foreach my $sid ( split(/[,\s]+/, $opt{s} )) { - push @where, "EXISTS ( select message_section_map.mid from message_section_map where message.mid=message_section_map.mid and message_section_map.sid = $sid )"; + push @where, "message.mid = msp$sid.mid"; + push @where, "msp$sid.sid = $sid"; + $table{"message_section_map msp$sid"}=1; } } } else { |