400,000 Records. Need help with performence
I have a table that has over 400,000 Records. Finds are taking over 3 minutes to perform.
The server is running windows xp/3Ghz/3G of ram.
What should i upgrade ? Should i add more Ram/CPU ? Do the client computers need an upgrade too ?