Thanks. I have about 1 million records, but my machine is not so
good. Its a core2 duo with 2 Gig of RAM. When I do only select it
takes a few seconds, but some of my reports require joins, and thats
a big problem.
Thiago
Well, i wouldn't recommend delete, as that would keep mysql very
Hi everyone,
I have a few asterisk machines doing PSTN calls, and I keep track of
all cdr in a single machine running mysql 5. Since I have a very
large amount of records in there, its getting pretty slow to query
the database, so I'm wondering if anyone does some type of log
rotating, like save
On 1/22/08, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi everyone,
I have a few asterisk machines doing PSTN calls, and I keep track of
all cdr in a single machine running mysql 5. Since I have a very
large amount of records in there, its getting pretty slow to query
the database, so I'm
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 11:44
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] Rotating CDR records inside mysql - anyone does it?
Hi everyone,
I have a few asterisk machines doing