A server is MS SQL Server2000 server, the client program to use for many years, is normal, but now use the client program found that query a database when a table is very slow, view the data table records article 4 million,

Copy the database to a personal computer, using MS SQL Server2000 personal version of the test, the client program is just slow to execute the query for the first time, after normal soon, and as long as MS SQL Server2000 personal edition is not stopped, the client application program even is turned off, again use, still normal soon,

But on the server, it is every query slowly

What reason? How to solve?