Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Table Size

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Table Size

    Hi All,

    Could somebody clear this up for me,

    I have taken over support on a application, one of the table has a size even after compacting of 2,050,828.

    What is the maximum size a table can be is it 2gb? the total size of the database is 5.56gb, and the table is growing ever day

    Andy

    #2
    Re: Table Size

    Originally posted by [email protected] View Post
    Hi All,

    Could somebody clear this up for me,

    I have taken over support on a application, one of the table has a size even after compacting of 2,050,828.

    What is the maximum size a table can be is it 2gb? the total size of the database is 5.56gb, and the table is growing ever day

    Andy
    The max size is 2 gig. You may find that they have never removed any outdated records, never packed after deleting records, etc. You may have to copy old records to an archive table if they must preserve them.

    What is the record count in this table? How many fields and do they still populate and use the data in all of them?
    There can be only one.

    Comment


      #3
      Re: Table Size

      Hi Stan,

      I was down there on Sunday packing and re indexing it had not been done for six months, the problem I have is that there is no archive procedure in place and I am still trying to work out what the affect on the sets will be if I remove some old data in this table. So it looks as if I will be working another Sunday very soon.

      What will happen when the table goes over 2gb

      thanks

      Andy

      Comment


        #4
        Re: Table Size

        Andy,

        If I've got my thinking cap on straight, 2 gb is approximately 1,000 times larger than your 2 mb file. If a problem is coming it may not be coming as soon as you were thinking.

        -- tom

        Comment


          #5
          Re: Table Size

          Originally posted by [email protected] View Post
          What will happen when the table goes over 2gb
          It can't, so I imagine there will be some kind of can't save record error.

          Tom may be right but I'm thinking you are quoting 2,050,828 kb as seen in explorer.
          There can be only one.

          Comment


            #6
            Re: Table Size

            Hi Stan/Tom

            Yes Stan you are correct, so It may be coming sooner rather than later!

            Andy

            Comment


              #7
              Re: Table Size

              I believe the 2 GB max file size was imposed by the operating system, not by the DBF file structure itself. So if the OS can support files larger than 2GB it won't be a problem. There's a maximum of, I think, 4 billion records in a dbf table. And I believe that with FAT32 the Windows OSes support file sizes of 4GB, not 2GB; if they use a Linux server even that file size limit disappears. And the NTFS file system supports larger file sizes. You have to find out what OS the system is running on.

              Comment


                #8
                Re: Table Size

                Just did a little search--NTFS supports 16 Terrabyte file size.


                Mike
                Mike
                __________________________________________
                It is only when we forget all our learning that we begin to know.
                It's not what you look at that matters, it's what you see.
                Henry David Thoreau
                __________________________________________



                Comment


                  #9
                  Re: Table Size

                  Well, I think I'm wrong. According to Microsoft, who should know, the maximum size of a Visual Foxpro dbf file is 2 GB, independent of the OS system maximum file size:
                  http://msdn2.microsoft.com/en-us/lib...w9(VS.80).aspx

                  Comment


                    #10
                    Re: Table Size

                    I found this at the following link.

                    The file format can also be an issue. The maximum size of a .DBF file is
                    2GB. That is because the file has to contain offsets to various other
                    locations within the file, and those offsets are based on 32-bit
                    integers. No software that is writing to a .DBF file can get around
                    this. Ideally, the software should detect when it it has written as much
                    data that the output file format can accommodate, refuse to write any
                    more, close the file, and inform the user of the situation. If the
                    software keeps writing then all it will do is convert a maximum-sized
                    file that is at least usable into a corrupt file that may contain more
                    data but is unusable because of messed up offset values.
                    Tim Kiebert
                    Eagle Creek Citrus
                    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

                    Comment


                      #11
                      Re: Table Size

                      Andy,

                      The file limit of 2 Gig applies to 1 file, so if you link a bunch of smaller tables, or put different memo fields in their own linked tables (recommended, but let's not get in that discussion here), then the sizes can normally be kept under the 2 Gig limit. Or use an SQL table, and there is no practical limit.
                      Regards,

                      Ira J. Perlow
                      Computer Systems Design


                      CSDA A5 Products
                      New - Free CSDA DiagInfo - v1.39, 30 Apr 2013
                      CSDA Barcode Functions

                      CSDA Code Utility
                      CSDA Screen Capture


                      Comment


                        #12
                        Re: Table Size

                        Hi All

                        Thanks for your replies, It looks as if I need to get this sorted out ASAP. One thing that has confused me a little if the file, is now 2,050,828kb isn't this file already over 2gb?

                        Andy

                        Comment


                          #13
                          Re: Table Size

                          Originally posted by [email protected] View Post
                          One thing that has confused me a little if the file, is now 2,050,828kb isn't this file already over 2gb?

                          Andy
                          Byte capacities are calculated on doublings of 2. In other words, a kilobyte isn't exactly 1,000 bytes; it's actually 2 raised to the 10th power, or 1,024 bytes. Two KB is 2 raised to the next step, the 11th power, or 2,048 bytes. Four KB is 2 raised to the 12th power, or 4,096 bytes. (Note that in this progression there is no such thing as "3 KB".) And so on.

                          2 gigabytes is actually 2 raised to the 31st power, or 2,147,483,648 bytes.

                          Based on this calculation, you haven't reached the limit yet.
                          Jim

                          Comment


                            #14
                            Re: Table Size

                            Funny thing,

                            I just took a 15 meg dbf file(packed) and split it into 2 tables, got rid of a couple fields that had never been used and now the 2 tables are under 10 megabytes. also to connect the 2 properly within sets I have 3 fields that are duplicates.

                            Dave
                            Dave Mason
                            [email protected]
                            Skype is dave.mason46

                            Comment


                              #15
                              Re: Table Size

                              One thing that has confused me a little if the file, is now 2,050,828kb isn't this file already over 2gb?
                              No, but you are getting very close.

                              2 GB= 2,147,483,648
                              Got 96,655,648 left

                              P.S.
                              These limits are abritrary and cautionary, but if I were you, I wouldn't push my luck.

                              Comment

                              Working...
                              X