1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Optigold File Sizes - Have we reached the limits of the System?

Discussion in 'Optigold ISP' started by duanekrobinson, Jun 4, 2004.

  1. #1
    Over the last 3 years our company has been fortunate enough to achieve a great deal of success in our market.

    We purchased Optigold when we were a 5 person shop. Since that time we have grown to almost 250 employees. We have kept Optigold throughout the entire journey but have recently started to experience lots of issues with the system. One possibility is that we are using the system incorrectly (I am going to arrange for someone at DigitalPoint to visit us for a consultation visit). However, I also have growing concerns that we may have reached the limits of the Optigold system. I am curious if any other Optigold users are storing similiar volumes of data in the system.

    We currently have:

    69,000 Plus Customer Records
    500K Invoice Records
    2.3 million line item records
     
    duanekrobinson, Jun 4, 2004 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    What's the file size of your largest database file?
     
    digitalpoint, Jun 4, 2004 IP
  3. duanekrobinson

    duanekrobinson Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Our lineitems.fp5 file is 762 Megabytes in size
     
    duanekrobinson, Jun 4, 2004 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    You are definitely within the size limitations (I believe there is a 2GB size limitation, but I think that's imposed by the operating system, rather than the database server itself. So it shouldn't be an issue.
     
    digitalpoint, Jun 4, 2004 IP
  5. duanekrobinson

    duanekrobinson Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    A filemaker consultant from the Moyer Group said that any filemaker file with in excess of a million records is excessive.

    He mentioned something about certain functions needing to perform calculations (in calculated fields) on every record and that if you have millions of records this could cause very slow performance on functions needed to do these recalculations.

    What are your thoughts?
     
    duanekrobinson, Jun 4, 2004 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    That's true about the calculations, although there is nothing in there that does any recalculations on all the records.
     
    digitalpoint, Jun 4, 2004 IP