tickerboo2002 wrote:

> A customer has moved server from an XP machine to a a super-duper
> Win2003 PC and is experiencing big query slow downs.
>
> Details:
>
> Win2003 R2, two dual core Xeons, 4GB ram, database installed on a raid
> 5 disk array.
>
> Running FBv1.53 SS as a service+guardian.
> CPU Affinity=1.
> No virus checker running
> 1 database (.fdb ext) around 35MB in size.
>
> The local protocol doesn't work, I need to add "localhost" to all
> gbak/gsec usage.
>
> The users (3 of them) are experiencing a slowdown when when moving
> from screen to screen (which fires off queries). These queries
> previously had sub-second response times on the XP PC, but now take
> anywhere between 10-60 seconds depending on the query.
>
> At first, it seemed as though there were no indexes, so I performed a
> back-up and restore (that does rebuild the indexes doesn't it?). No
> change.
>
>
> Any further suggestions?
>
> TIA
>
> David
>
>

Look for the plans of the slow queries on the former machine and compare
it to the new one.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br