Re: Oracle V MS-Access

Also there is a difference between Access and Oracle concerning network traffic.

Oracle is a true SQL server, while Access is (based upon) a desktop database technology.
The difference lies in that when you ask for a few records from Oracle (from lets say a table with thousands/millions of records), you get only the records you asked for sent to you over the network.

A desktop database, however, sends you the entire table over the network.

I do not know if Access in some way have worked around this (you should find this out),
but if this is the case, you have one more (major) point in favour of Oracle.

RCS Tom Kelsall <tom_krm_at_my-deja.com> wrote in message news:8bg7b4$2re$1_at_nnrp1.deja.com...
> Thank you very much - this is exactly the sort of thing I was after.
>
> In essence, then:
>
> > Response times will suffer in MS-Access with a large number of users
> (Lets say, more than 50?)
>
> > Large databases (Like consumer demographics) would take a huge
> performance hit.
>
> > Access cannot be used (viably) 24x7; no "hot-backups", "hot
> maintenance" or "hot repair".
>
> Are there any more? Have I got these right?
>
> Thanks again
>
> --
> Tom Kelsall HND MCP
> "Integer vitae scelerisque purus"
> (Quintus Horatius Flaccus - Odes)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 25 2000 - 06:59:28 CST