Jump to content

Reducing database size


This topic is 1162 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi All. I have a database that is currently sitting on 760MB with 425K records and from the trend it will grow at about 200K records a year now. as it is primarily used on mobile devices I think that this growth will lead to local processing problems. I am looking for a way to "hive off" any records older than say 18 months in the distributed version of the database while keeping all records in an "archive" version and then be able to add new and modified records monthly to the "archive" and removing the oldest month from the distributed version. There are 27 tables involved. Any pointers for achieving this would be appreciated *

Link to comment
Share on other sites

when you say distributed version are you saying it is off line or is the main file hosted?

One solution to my mind is use of MirrorSync to keep a central database of all data hosted and users could sync down only a subset of records. 

 

Link to comment
Share on other sites

7 minutes ago, Ocean West said:

when you say distributed version are you saying it is off line or is the main file hosted?

One solution to my mind is use of MirrorSync to keep a central database of all data hosted and users could sync down only a subset of records. 

 

The working files are offline and the main file is hosted. We spend a lot of time without even electricity never mind an internet connection in South Africa so we cannot work with an online file. We do in fact use Mirrorsync. It is not the data being synced that is starting to create problems it is the volume that has to be found and organised while on site. There is also the consideration of expensive bandwidth. If 20 people have to download a new file in the morning and perform a first sync that creates problems on our meagre resources so the idea is to minimise the data that the mobile devices have to both download and process while somehow also keeping a total database with the historical data that we need.

Link to comment
Share on other sites

It is exactly the same and when any development takes place,(at least once a week), a new file must be downloaded to each device and an initial sync has to take place. 

Link to comment
Share on other sites

This topic is 1162 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.