[Asterisk-Users] CDR records into SQLite

[brian]

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.

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: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
> admin at lists.digium.com] On Behalf Of Holger Schurig
> Sent: Wednesday, July 07, 2004 5:02 AM
> To: asterisk-users at lists.digium.com
> 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users