|Subject||Re: SubSelect problems|
> 2) If you were in my software team I'd send you away with a flea in:) I understand that, but even with this First() function query works
> your ear and tell you to write a decent stored procedure.
fast enough. So firebird if faster than old dos app written on Pascal :)
What I figured out is:
Before this query I delete tons of records. After 20 000 by default fb
starting sweep. And it is slowing down this query that bad. So far it
is not final source of this problem. I turned off auto sweep, but this
happening again. At some moment cpu load jump to 100% and stay this
way all the time, like doing sweep. I cancel and start again without
deletion just select, sweep starts again. Is this possible?