Re: efficiency problem

A properly designed Access application will do the job as well as any other, probably better than most, if you are talking small numbers of concurrent users.

Contrary to what you might think, it is almost always factors that are external to the data application software that have the most noticeable performance-deterioration effects by far. For example, network performance factors and workstation efficiency can have performance effects that can be several orders of magnitude greater than the software itself.

--
Pete B


KAROL SUDNIK <KS315_at_mdx.ac.uk> wrote in message
news:3A311975.339938B8_at_mdx.ac.uk...


> Hi,

>

> I have a question I hope someone can help me with...


> I want to create a database consisting of 10 tables, capable of holding

> aprox. 100 000 entries each. I need to perform cross queries between

> these tables (I mean that I need to do multidimensional statistical

> analysis).  These queries must give quite fast answers (I want to

> present results graphically). Is it possible to create such, efficient

> database using quite cheap software for ex. MS Access? Program which I

> build should work within Windows environment (that is why I mentioned

> Access).

>

> thanks,

> Karol

>