Welcome to WebmasterWorld Guest from 54.205.251.179

Forum Moderators: phranque

Message Too Old, No Replies

XP Pro or Server 2003 for my needs

   
2:54 pm on Jul 21, 2004 (gmt 0)

10+ Year Member



Hello,

I currently have a small business that has about 3 computers networked together and they all share a common file (Microsoft Access Database) off my XP Pro desktop. It's a desktop application so I can't switch it to MySQL.

The only problem is that on the computers other than my desktop, access to the file is a little slow (60MB .mdb file), and my desktop does not have a RAID 1 setup in case of hard disk failure.

I was at first considering setting up a Server 2003 on a new computer build but I am worried this might be above my head and I will have to spend too much time on administration. I only need to share one large file and I only need one Remote Desktop license.

I also don't plan on reaching the 10 user limit in XP pro for file sharing any time soon. For security, I also plan on switching from Simple File Sharing to Advanced Sharing with Users and Permissions for each file share.

Considering this, should I just install XP Pro on a faster machine with Raid 1 and use that as my file server/desktop or would Server 2003 be necessary.

I already own Server 2003 and 25 CAL's from a class I took, but it is also confusing if these licenses also let me use Terminal Services or something extra needs to be bought.

Thanks!

3:07 pm on Jul 21, 2004 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Most likely the slowness comes from using the Access file as your database. There is no reason why you can't use mySQL on the XPPro machine - it works just fine.
3:18 pm on Jul 21, 2004 (gmt 0)

10+ Year Member



The Access file is basically a desktop application utilizing all of Access's forms and module features.. It's a packaged app sold by a third party, not a custom written app by myself. That's why changing that to MySQL is not really an option.

Thanks.

3:29 pm on Jul 21, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If you're not using gigabit networking that's the problem, if you install a gigabit network, which is very easy to do, all you need to do is get a gigabit switch, gigabit networking cards, and you're set.

You can also replace the ethernet cabling with cat6 or at least cat 5e, although I've found that even cat 5 is fine.

If you are using a wireless network of course that's the problem re speed issues.

I've found gigabit networking large file transfer speeds are very comparable to internal ide transfer speeds, close enough to not make that much difference as far as users are concerned.

9:35 pm on Jul 21, 2004 (gmt 0)

10+ Year Member



Thanks for the info. So the network is probably the bottleneck and not the host computer. The computer sharing out the file is a P4 2.66 533Mhz FSB and has 512 MB Ram. I will try out the Gigabit Network solution.

So if I am currently operating on a Linksys BEVP41 Router, I just need to by a Gigabit switch and hook that up to the router and hook all the internal computers up to that in order to have a Gigabit network internally?

Thanks.

9:47 pm on Jul 21, 2004 (gmt 0)

10+ Year Member



Yes you just have to get a Gigabit switch, and make sure all of your computers have Gigabit network card also.

<spelling>