After the thread about Vista I wondered if I could pick your brains on a variation.
We need new PCs at work for running some rather hefty Microsoft Access databases, and I am trying to find out what makes Access work quickly. We are connected to a network, and obviously running with any linked databases on the local drive, rather than the network speeds things up, but this is not always suitable.
The databases contain tables, or links to tables with up to a million or more records in them, and when compacted are in the 0.5 to 1.5 GB region.
We are quite used to them being slow, but are about to embark on building some new models and would like something quicker, while in the writing queries and macros stage. Should we concentrate the expense on Memory, or processor, or what?
Which of the newer generation of processors are most suitable, and which should be avoided for this purpose?
Thanks
We need new PCs at work for running some rather hefty Microsoft Access databases, and I am trying to find out what makes Access work quickly. We are connected to a network, and obviously running with any linked databases on the local drive, rather than the network speeds things up, but this is not always suitable.
The databases contain tables, or links to tables with up to a million or more records in them, and when compacted are in the 0.5 to 1.5 GB region.
We are quite used to them being slow, but are about to embark on building some new models and would like something quicker, while in the writing queries and macros stage. Should we concentrate the expense on Memory, or processor, or what?
Which of the newer generation of processors are most suitable, and which should be avoided for this purpose?
Thanks