Subject Re: [firebird-support] Re: How to make my report quicker
Author Alexandre Benson Smith
heroes3lover wrote:
> Thanks Sean,
> you reply so quick!
> The SQL for one store is not bad, and the plan is good, I have double
> check with my workmates.It should not be the bad performance of
> database. As I said, there are more than 400 stores in this group, if I
> analyze stores one by one, one store use 1 minute, and 400 stores will
> be 400 minutes, it is 6 hours.
> Maybe should do something on the database design, can fix this issue.
> Do you have some idea about that?
> Thank you very much
> Roc


Maybe 1 minute is just to long too...

The best we can do will be after we se your query and the generated
plan and you provide as much info as possible.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil