If you check Microsoft's page: [microsoft.com...] which covers the different editions of Server 2003, you'll see right away that the web edition does NOT support 64 bit computing. You'll be spending money for no reason there.
Also, you are limited to 2Gig of RAM with web edition. If your site keeps growing and so does the number of database queries, you'll run into your RAM limitation.
Also, from the mySQL site regarding windows 2003 edition compatibility:
Microsoft Windows XP (AMD64) LS Windows XP (EM64T) LS Windows 2000 (x86) CS Windows XP (x86) FS Windows 2003 (IA64) LS Windows 2003 (AMD64) LS Windows 2003 (x86) FS
FS = Full support CS = Conditionally Supported LS = Limited Support
Q. What is Limited Support (LS)? A: These are specific operating system and hardware combinations for which mySQL provides only limited support. For this tier, mySQL does not have the target OS/hardware; and mySQL does not build binaries for these combinations; and mySQL does not test on these platforms. The mySQL Support Team will use commercially reasonable efforts to attempt to provide technical support for these platforms, but with the customer's acknowledgement that there may be scenarios that cannot be resolved due to the above limitations.
Note the fact that the 64 bit version of Server 2003 has limited support and mySQL might not function correctly in that environment. Also, the only certified binary they have for Windows is for the x86.
Guess its decision time or back to the drawing board.
Hope this helps.
[edited by: SEOMike at 4:50 pm (utc) on July 19, 2005]
It's going to be windows 32 bit version. I think the chip is also 32 bit but has Intel's 64 bit memory extension. I'm using Windows 2003 web edition sucessfully now, so I hope that it continues to work well. Thanks though for the great info!
I think you're probably oversubscribed.for 500-1000 visits a day. That's like 3 visits a minute.
You should consider two changes to that machine, just because you're putting your business on a lightweight machine. First, as noted, put in way more memory. 1 gig is probably fine, but still, it's a fast and cheap way to solve a lot of problems. Second, spend the money on scsi drives. Still faster and more reliable that sata drives - that's why once you leave the lower end Dell servers you'll only find scsi is the only option.