callaccounting.ws forum

callaccounging.ws => Call Accounting Mate Q&A => Topic started by: wgheath on January 30, 2007, 02:31:45 PM

Title: Maximum Database Size
Post by: wgheath 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?
Title: Re: Maximum Database Size
Post by: Administrator 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
Title: Re: Maximum Database Size
Post by: svinyard on May 22, 2007, 12:08:01 PM
How does one create this policy?
Title: Re: Maximum Database Size
Post by: Administrator 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