Limits of Access 2 and Capacity
Nigel House
Hi,
so what are the size limitations of an *.mdb in terms of size and how
can we calculate the capacity that we need?
At what size of an *.mdb will it fall apart. 500Mb? 1.5 Gb?
--
Nigel House
nig...@intercoast.com.au
http://www.notyetup.com.au
Sundial Services
>Hi,
>so what are the size limitations of an *.mdb in terms of size and how
>can we calculate the capacity that we need?
>At what size of an *.mdb will it fall apart. 500Mb? 1.5 Gb?
>--
The official theoretical-capacity numbers are published in an appendix of the
user's guide; I believe it's still 1GB per MDB.
Access does store records using a variable-sized format; a text field occupies
storage only as needed, for example.
But as to the capacity and size .. and whether it will 'fall apart' (whatever
that means to you), I maintain that the only way to determine this reliably is
to devise and carry out a test. Before you build the application, use a test
data generator to create tables with a realistic quantity of data. An
aggressive, worst-case quantity of data if you can. Develop the queries you
think you'll need to run when the system is in use. Run these queries and
time them.
If the system's not going to work well with the load -you- anticipate, then
isn't the right time to discover this .. -before- the system is built, and not
after? :-/
/mr/
Jeff North
On 6 Feb 1997 20:50:18 GMT, nig...@intercoast.com.au (Nigel House) wrote:
>Hi,
>so what are the size limitations of an *.mdb in terms of size and how
>can we calculate the capacity that we need?
>
>At what size of an *.mdb will it fall apart. 500Mb? 1.5 Gb?
>--
>Nigel House
>nig...@intercoast.com.au
>http://www.notyetup.com.au
Hi Nigel,
fire up help | Contents | Reference Information | Microsoft Access
Specifiactions. This will give you an overview of the database.
If you want to get to the nitty gritty of field information the look under
data types.
For more specific information about indices etc you might want to look at the
Jet White Paper from the Microsoft web site.
I've seen users posting here that state that they have 750mb databases and
have no trouble with that size - but then I've seen other postings where the
size was under 10mb and gave nothing but trouble.
Just a thought
----
Regards