Strange question i know but..
Our small office is growing, I need to either a) buy some network attached storage or b) buy a proper file server. I would rather do a) as it is cheaper and simpler, and still allows me to organise backups of all our data.
However, I expect next year we will need to get a database server (currently we all use MS Access through a shared file on a Win98 machine, so I realise it will begin to slow down as the database grows as the whole table is read over the network for each request by each machine). If we have a database server programme running on a machine (SQL Server/MySQL?), will it connect to the files stored on the Network AND NOT need to access and read all the tables every time its asked a question? I realise that a database server will reduce the network traffic as it only sends the results of a query, and not the whole table. But if the database has to read the whole table in for each and every request over the network, then there is no point me buying network storage now and expecting it to handle our growth later on.
I hope that makes sense, and if anyone can let me know which way it works I'd be much obliged.
Thanks,
Steve Root --
Steve Root
Our small office is growing, I need to either a) buy some network attached storage or b) buy a proper file server. I would rather do a) as it is cheaper and simpler, and still allows me to organise backups of all our data.
However, I expect next year we will need to get a database server (currently we all use MS Access through a shared file on a Win98 machine, so I realise it will begin to slow down as the database grows as the whole table is read over the network for each request by each machine). If we have a database server programme running on a machine (SQL Server/MySQL?), will it connect to the files stored on the Network AND NOT need to access and read all the tables every time its asked a question? I realise that a database server will reduce the network traffic as it only sends the results of a query, and not the whole table. But if the database has to read the whole table in for each and every request over the network, then there is no point me buying network storage now and expecting it to handle our growth later on.
I hope that makes sense, and if anyone can let me know which way it works I'd be much obliged.
Thanks,
Steve Root --
Steve Root
