>>
>>IMO, speed is not a reason to move to SQL Server. Table size, security, decreased network traffic, and remote users are good reasons. I've managed DBFs with 11,000,000 records (1.7 Gig) just fine.
>
>
>What kind of hardware did you do this on?
>
>I've never worked with milion+ record dbf tables personally. One developer in our org who has, claims when you get table close to a million, you get major peformance hits. Even parameterized views loading a few thousand records out of the million take forever.

Pulling a few thousand records from any backend will take a while. What kind of processing needs to deal with that many record at once???