Table size and network response time

[GeorgeMar]

I need a table with 4 fields, one date, three texts and one autonumber that
is also a unique number for a barcode ID.

The problem is that the table will have over 1 million records. I am
wondering how MS Access will cope and whether the users will be affected on
the LAN.

Does anyone use that sort of size and know what the response time is like?

Should I break up the table into 10 smaller tables?

regards
george

 

[Douglas J. Steele]

Even if it did result in a slight performance improvement (and I doubt very
much it would), you should not split the table into multiple smaller tables.
That would make managing your application much more work.

A million rows isn't that big. Unfortunately, without knowing how the
table's being used and what your network speed is like, it's not possible to
predict performance.

 

[GeorgeMar]

Douglas, Thank you for your help

Even if it did result in a slight performance improvement (and I doubt very
much it would), you should not split the table into multiple smaller tables.
That would make managing your application much more work.

A million rows isn't that big. Unfortunately, without knowing how the
table's being used and what your network speed is like, it's not possible to
predict performance.