How big a record size is too big from a performance standpoint?
in [Tables]
|
From: Dennis on 24 Nov 2009 11:25 Hi, I'm pretty new to Access and I would like to know from a performance standpoing if there is a record / row size that is too big for an Access database. My record size will be about 4k to 6k and I will have a max of 10,000 record. They will be multiple users (1 to 4) accessing the database. I think Access 2003 and above will handle this, but I wanted to make sure before I got to far into the project. Thanks, ----- Dennis -- Dennis
From: Jeff Boyce on 24 Nov 2009 11:52 Dennis Use Access HELP and check "specifications". I believe you'll find that the max record length in Access is 2K. That said, a record with that much data may result from a less-than-well-normalized table structure. If you'll describe more specifically what data you are trying to store in your table(s), folks here may be able to offer more specific suggestions. By the way, 10,000 records is a pittance ... no worries there. Multiple users is what Access handles straight out of the box ... no worries there. But, "it depends" ... performance is the result of a whole lot of factors. You've only posited one ... Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Dennis" <Dennis(a)discussions.microsoft.com> wrote in message news:F520EF3D-9152-4655-B3FE-6E3D9960F6FE(a)microsoft.com... > Hi, > > I'm pretty new to Access and I would like to know from a performance > standpoing if there is a record / row size that is too big for an Access > database. > > My record size will be about 4k to 6k and I will have a max of 10,000 > record. They will be multiple users (1 to 4) accessing the database. > > I think Access 2003 and above will handle this, but I wanted to make sure > before I got to far into the project. > > Thanks, > > > ----- > > > Dennis > > -- > Dennis
From: Keith Wilby on 24 Nov 2009 11:53 "Dennis" <Dennis(a)discussions.microsoft.com> wrote in message news:F520EF3D-9152-4655-B3FE-6E3D9960F6FE(a)microsoft.com... > Hi, > > I'm pretty new to Access and I would like to know from a performance > standpoing if there is a record / row size that is too big for an Access > database. > > My record size will be about 4k to 6k and I will have a max of 10,000 > record. They will be multiple users (1 to 4) accessing the database. > > I think Access 2003 and above will handle this, but I wanted to make sure > before I got to far into the project. > > How do you know how "big" each record is going to be? I think that as long as you have a normalised design and a split GUI you can't go far wrong, but there's no substitute for testing. Keith. www.keithwilby.co.uk
From: John W. Vinson on 24 Nov 2009 22:01 On Tue, 24 Nov 2009 08:25:01 -0800, Dennis <Dennis(a)discussions.microsoft.com> wrote: >Hi, > >I'm pretty new to Access and I would like to know from a performance >standpoing if there is a record / row size that is too big for an Access >database. > >My record size will be about 4k to 6k and I will have a max of 10,000 >record. They will be multiple users (1 to 4) accessing the database. > >I think Access 2003 and above will handle this, but I wanted to make sure >before I got to far into the project. Unless part of the data in the record is in a Memo field you're in trouble. The maximum size of a record (exclusive of Memo or GUI fields) is 2000 bytes. Annoyingly, you can easily create a table with (say) 40 Text fields each of 255 bytes, and even enter data into it - but you'll get an error message when you first try to save a record with more than 2000 bytes actually occupied. What is the structure of your table? How many fields, of what types? What sort of data is in these fields? Might you be able to normalize a wide-flat table into several related tall-thin tables? -- John W. Vinson [MVP]
|
Pages: 1 Prev: 怎樣downPowerPoint? Next: How big a record size is too big from a performance standpoint |