Author Topic: Maximum Database Size  (Read 4795 times)

wgheath

  • Newbie
  • *
  • Offline Offline
  • Posts: 1
    • View Profile
Maximum Database Size
« on: January 30, 2007, 02:31:45 PM »
My calls.dat file has reached 5GB - what is the largest that this database should get before purging data.  Reports are very slow and time out quite often?

Administrator

  • Administrator
  • Super User
  • *****
  • Offline Offline
  • Posts: 171
    • View Profile
Re: Maximum Database Size
« Reply #1 on: February 02, 2007, 09:47:43 AM »
The database is SQLite. The size of the database can go to a terabyte or more however you have to recognize that the more data you put in your system the more memory is necessary to retain speed.

The speed of your system is far more dependent on your processor and RAM than it is on the SQLite database.

You may want to set a policy for purging calls every 3-4 months to avoid carrying data that is no longer necessary. 

Regards,
Administrator

svinyard

  • Jr. Member
  • **
  • Offline Offline
  • Posts: 5
    • View Profile
Re: Maximum Database Size
« Reply #2 on: May 22, 2007, 12:08:01 PM »
How does one create this policy?

Administrator

  • Administrator
  • Super User
  • *****
  • Offline Offline
  • Posts: 171
    • View Profile
Re: Maximum Database Size
« Reply #3 on: May 23, 2007, 11:48:11 PM »
You will need to determine what management wants to do with the data.  If you wish to archive or purge the data, you can do so periodically using the Maintenance tools.

Regards,
callaccounting.ws