Thread: Re: Please help - performance problems

Re: Please help - performance problems

From
Gaetano Mendola
Date:
ctrl wrote:

> I have news...good news for me:)
> even though I wasn't able to find the answers I was looking for, I did
> something that made a big difference: by removing the ORDER BY clause,
> the same function takes now 5 milliseconds (instead of sometimes 10
> minutes).
> I have tried to vacuum, analyze, etc...nothing worked.
> I post this hoping it could help somebody.

How many memory are you using for the sort operations, is that column
indexed ?



Regards
Gaetano Mendola