On 21 September 2011 17:59, <hamann.w@xxxxxxxxxxx> wrote:
If I try to get many items on a prefix match
select code .... where code ~ wantcode
things go very slow. Explain shows a nested loop, so seemingly the table is rescanned
for every wanted item in the other table. A test run (3000 wanted codes against a
shortened table of 10000 ones) took about 200 seconds to complete
What is the output of explain?
You say 'the other table', so presumably we're dealing with a foreign key here. Is there an index on that column?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
