data transfer on network

  madPentium 21:35 02 Feb 2006

We have recently put a microsoft database on a pc and shared it to 3 other users. Its 24mb in size at the moment, but is expected to double in size in a very short time. It runs very fast on the host pc, but is quite slow to load on other machines. Network is running at 100, and all pcs are xp pro and intel processors all over 3 gig.
I was wondering if extra ram would maybe help? all pcs have 512mb.
Or, maybe the database should be on a seperate hard drive?

  Softstag 22:31 02 Feb 2006

I assume by Microsoft, you mean Microsoft Access?

Access is quite a bandwidth hungry application when used on a network. I would suggest if you are using a large database on a network that you look in to using SQL as this is much faster.

The limiting factor is the network, if you stick with Access then I would say the only way to improve performance is upgrade the network to Gigabit. More RAM will make no difference.

  madPentium 16:27 03 Feb 2006

thank you for your reply. Yes I was refering to MS Access. Do you know if SQL supports access files? or will the database have to be rewritten?

  Softstag 23:02 06 Feb 2006

Database would need to be rewritten. It is a completely different format, and much more powerful.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei MateBook X Pro review: Hands-on

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?