vb.net - "select count()" is very slow -

I have a database with 1,000,000 records and there is a query like this:

  Select count (code) from Table 1  

This works well on the local system but it becomes very slow on the network Other questions like Select * from the table Implement quickly, but select Counting from table 1 is very slow I can not change the structure of the database. My database is FoxPro and I use VB.NET.

Is there a solution?

Edit: Should I write the code like this?

, "dbl", "So how can I get the selection number (code) from dataset from Table 1

or I use LINQ

Edit 2: I mean select select count (*) and count (code) Comparison.
What is the solution?

will be faster to do this

  Select the count (*) from the table 1  

then count (code) .

to use