homepage Welcome to WebmasterWorld Guest from 23.22.217.122
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque & physics

Webmaster General Forum

    
XP Pro or Server 2003 for my needs
kjs50




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

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!

 

txbakers




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

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.

kjs50




msg:361876
 3:18 pm on Jul 21, 2004 (gmt 0)

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.

isitreal




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

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.

kjs50




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

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.

Dudermont




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

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

<spelling>

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved