Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and 64 bits SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01268595
Message ID:
01268644
Views:
14
>>>There's no difference in accessing 64-bit SQL Server from outside.
>>>
>>
>>And it is very noticeably faster than 32-bit SQL Server!
>
>Because it's running on better hardware. :)

Not necessarily.

Last year we upgraded a dual Xeon server from Win Server 2003 w/SQL 2005 to Server 2003 X64 w/SQL 2005 x64. we had been running a large production database for about 6 months on 32 bit before upgrading (I finally convinced the IT folks that 64bit Windows wasn't a bad thing).

Performance on queries that had been somewhat slow (things that took a few seconds or more) were considerably faster on the 64bit version.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform