Aurora 4x

Starfire => SA Questions => Topic started by: Tregonsee on November 26, 2008, 05:36:09 PM

Title: Max Database Size and Slimming
Post by: Tregonsee 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

Title: Re: Max Database Size and Slimming
Post by: Erik L on November 27, 2008, 11:00:08 AM

In Access, compact the databases before combining them. That will probably help some.

Title: Re: Max Database Size and Slimming
Post by: Tregonsee 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

Title: Re: Max Database Size and Slimming
Post by: Kurt 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

Title: Re: Max Database Size and Slimming
Post by: Shinanygnz 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

Title: Re: Max Database Size and Slimming
Post by: Tregonsee 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

Title: Re: Max Database Size and Slimming
Post by: Steve Walmsley 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

Title: Re: Max Database Size and Slimming
Post by: Tregonsee 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