On Jul 7, 2004, at 6:59 AM, brian wrote:
I don't get why we need this. cdr_odbc.c has this covered. Also Josh has
some info on how to compile cdr_odbc using iodbc libs instead of unixodbc.
Well not quite. As shipped I couldn't make cdr_odbc.c work with SQLite. I've patched it, and it works well for my purposes. If anyone wants to submit the patch please feel free to do so. I currently have CDR's logged via unixodbc-2.2.8 and the sqliteodbc-0.62 driver.
See http://www.sonic.net/~dcreemer/cdr_odbc-update.patch
-- David
cdr_sqllite.c and cdr_tds.c were both written and not needed. I'm not
trying to discourage anyone from writing anything but why were these needed?
http://www.unixodbc.com/drivers.html
bkw
-----Original Message----- From: [EMAIL PROTECTED] [mailto:asterisk-users- [EMAIL PROTECTED] On Behalf Of Holger Schurig Sent: Wednesday, July 07, 2004 5:02 AM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] CDR records into SQLite
Do you know how many thousands?
No. This depends on your machine, the type of queries you make etc.
But hey, as this uses SQL, you can add and drop indexes at will, even while Asterisk has the cdr.db file open.
For example, when you need to select quite often by the destination and
you think that is slow, then just create an index on-the-fly:
$ sqlite /var/log/asterisk/cdr.db SQLite version 2.8.0 Enter ".help" for instructions sqlite> create index cdr_dst on cdr (dst); sqlite> .exit
See the documentation at http://www.sqlite.org (especially in their wiki)
for optimizations and so on. I only have a few records in the database,
because I don't (yet) use Asterisk in real life for the whole office.
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
