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

maximum # records

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

    maximum # records

    what is the maximum number of records that alpha will handle. yeah, yeah, i know all about the linked tables from access crap, but they have a 2gb limit. what i want to do will be way bigger than that. is their a functional limit for alpha, and if so, will any other database package be able to handle a hundred million records with three to four fields without linking tables.?

    the total size would be around 10-15gb, and i need it in a single table.

    #2
    RE: maximum # records

    I'm not real sure of this but seem to recall a 2 gig limit. Ver 6 will work with various types of sql so that may be a better choice. If you started development in v5 I'm sure the conversion to v6 would be easy enough when it comes out.


    Russ

    Comment


      #3
      RE: maximum # records

      Hello Web Developer,

      The 2 gig limit is the file size limitation under older versions of windows. I do not think that the NTFS has this limitation.

      I'm not sure if there is a theoretical limit on number of records in a table. I know I've heard the 2 billion number before. But again, I'm not sure that this is a limitation of the dbf file format.
      Jim

      Comment


        #4
        RE: maximum # records

        I found this on the Sequiter site:

        "CodeBase 6.4 now lets you surpass the standard xBASE limit of one gigabyte per table when using our 32-bit FoxPro compatible libraries. Depending on the size of your indexes, you can create tables with a theoretical maximum size of 4.2 million terabytes (4,611,686,018,427,387,904 bytes), large enough for virtually any application today or in the foreseeable future!"

        Jim

        Comment


          #5
          RE: maximum # records

          no, it's not a windows limitation, it's in access. it's in the help file, and trust me right at 2gb, things get squirrelly. if you try and go over the limit, you'll lose the data. (speaking from experience)

          does any version of alpha get around this? i am using win2k with NTFS so in theory the file size can be as big as my hard drive right?

          if not alpha can someone turn me on to a dbase that can handle it that would be user friendly. it does not have to be that feature rich, just updating, querying, etc. and i don't want to buy a machine and do a sql server or anything like that. i'm not looking to reinvent the wheel here. hell i could almost use a spreadsheet if it could handle the data. doesn't paradox handle more records than access?

          Comment


            #6
            RE: maximum # records

            I poked around a little more on the sequiter site and found the following:

            The maximum table size is 4.2 billion gigabytes (4,611,686,018,427,387,904 bytes). This is large enough for any application today or in the foreseeable future.

            The maximum size of index files, which contain sort information, is 4096 gigabytes. Also, our index files support compression to improve speed and save on disk space, which further increases capacity. We estimate that a table containing four indexes, each built on a 15 character field, could support approximately 125 billion records.

            Comment


              #7
              RE: maximum # records

              i must have been there same time as you. thanks big help. it's only a couple hundred. but i wanted to give alpha the biz. are we sure that it can't handle it?

              someone told me on another board that the new access xp removed the limit, and was now only limited by hard drive space. but it seems so damn slow. i was hoping some "expert" could set me straight. lol

              Comment


                #8
                RE: maximum # records

                Hello Web developer,

                I know Access has a 2 gig limitation. I was making the comment that Russ might be thinking of the old FAT (FAT16) limitation of 2 gigs, as Alpha does NOT have a 2 gig limitations.

                Jim

                Comment


                  #9
                  RE: maximum # records

                  Jim,

                  The DBF format Alpha Five presently uses reserves 4 bytes (32 bits) in the header of each DBF table for the number of records in that table. Until Alpha leaves the Foxpro 2.6 format I think the max number of records that a table can hold is capped at about 1 billion records. (2 to the 32nd power - 1, or some such). The max file size will be determined by operating system constraints, I should think, and will vary depending on the size of each record.

                  -- tom

                  Comment


                    #10
                    RE: maximum # records

                    4 bytes will store any digit up to 4,294,967,295 - about 4.3 billion records.

                    That should be the limit to a table until they change the header format and go to 5 or 6 bytes for the record count.

                    leon brachman
                    [email protected]

                    Comment


                      #11
                      RE: maximum # records

                      For what its worth

                      I run an application with 40,000,000 records in it with 12 fields per record

                      John
                      Failure makes improvements

                      Comment

                      Working...
                      X