Author Topic: Max Database Size and Slimming  (Read 1016 times)

0 Members and 1 Guest are viewing this topic.

Offline Tregonsee

  • Sub-Lieutenant
  • ******
  • Posts: 104
Max Database Size and Slimming
« on: November 26, 2008, 05:36:09 PM »
Is there a maximum size of the database in SA?  Is it dependent on the version (SA 7.0 can handle a large (over 100mb) database better than older versions)?

I am about to take a 147mb database, add more data to it, in order to run battles and stuff.  Do I need to trim the size of the database, and if so, how can I easily trim the size?

Steve G
 

Offline Erik Luken

  • Administrator
  • Admiral of the Fleet
  • *****
  • Posts: 5135
  • Thanked: 114 times
  • Discord Username: icehawke
Re: Max Database Size and Slimming
« Reply #1 on: November 27, 2008, 11:00:08 AM »
In Access, compact the databases before combining them. That will probably help some.
 

Offline Tregonsee

  • Sub-Lieutenant
  • ******
  • Posts: 104
Re: Max Database Size and Slimming
« Reply #2 on: November 28, 2008, 07:53:57 PM »
I am not sure about how to compact them (I have never used Acess), but if there is no upside limit, then it does not matter, right?  Or I can wait until it gets closer to that upside limit.

Steve G
 

Offline Kurt

  • Global Moderator
  • Rear Admiral
  • *****
  • Posts: 937
  • Thanked: 20 times
Re: Max Database Size and Slimming
« Reply #3 on: November 29, 2008, 08:00:10 AM »
Quote from: "Tregonsee"
I am not sure about how to compact them (I have never used Acess), but if there is no upside limit, then it does not matter, right?  Or I can wait until it gets closer to that upside limit.

Steve G


The is a limit on size, but I believe it is close to 1,000 meg's.  

Kurt
 

Offline Shinanygnz

  • Lieutenant
  • *******
  • S
  • Posts: 175
  • Thanked: 1 times
Re: Max Database Size and Slimming
« Reply #4 on: November 29, 2008, 08:38:12 AM »
The limit is 2Gb I think, same as MSDE.
There's an option on the Miscellaneous menu in SA to Compact the database.
Access is a swine for growing the db, so use the option provided by the good Mr W

Stephen
 

Offline Tregonsee

  • Sub-Lieutenant
  • ******
  • Posts: 104
Re: Max Database Size and Slimming
« Reply #5 on: November 29, 2008, 12:36:06 PM »
Ok, thanks all.  I think I will not have to worry about size for a while then.  Now is there a way to combine certain aspects of two databases together?  I need to be able to add fleet data from one database to another in order to use the battle calculator
 

Offline Steve Walmsley

  • Aurora Designer
  • Admiral of the Fleet
  • S
  • Posts: 6941
  • Thanked: 1739 times
    • http://www.starfireassistant.com
Re: Max Database Size and Slimming
« Reply #6 on: December 04, 2008, 10:55:44 AM »
Quote from: "Tregonsee"
Ok, thanks all.  I think I will not have to worry about size for a while then.  Now is there a way to combine certain aspects of two databases together?  I need to be able to add fleet data from one database to another in order to use the battle calculator
No, you can't combine databases because of the Unique ID problems. I guess it would be possible to write an application to do it, depending on what information you wanted to combine, but it would be a lot of work.

Steve
 

Offline Tregonsee

  • Sub-Lieutenant
  • ******
  • Posts: 104
Re: Max Database Size and Slimming
« Reply #7 on: December 04, 2008, 11:20:55 AM »
What I would like to do is add fleet data to an existing database so I can use the battle resolver. It is a shame that the battle resolver cannot take other databases for input.

Steve G
 

 

Sitemap 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52